this page sho you in how to retriev table info (like space used) from a
mysql table using myisamchk... Give it a look!
http://www.mysql.com/doc/T/a/Table-info.html
The trick would be create a virtual table by join and use this command to
mesure the amount of memory beeing used by each user..
What do you think?
Rom
----- Original Message -----
From: [ rswfire ] <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 2:42 PM
Subject: Re: [PHP] MySQL Disk Space Usage
Thank you for the reply, however, I do not believe this will solve my
problem. So please let me explain what I am trying to do.
I'll use an example. Let's say I have a guestbook application. And let's
say that several different people have their own guestbooks. I would create
a guestbook table with, let's say:
rowid
person_id
(...other fields...)
What I want to do is something like a SELECT query, where I select all of
the rows by person_id. Then, I want to find out how much DISK SPACE is
being used by these particular rows.
I am doing this to determine how much disk space is being used by any
particular client. Each client is allocated a certain amount of disk space
usage on my server and I need to determine how much space they are using in
the database.
Any ideas on how to do this in PHP???
Please email me directly with a response. Thank you!!!!!!!!
----- Original Message -----
From: Romulo Roberto Pereira <[EMAIL PROTECTED]>
To: [ rswfire ] <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 2:29 PM
Subject: Re: [PHP] MySQL Disk Space Usage
> I think that these are your answer:
>
> Memory use explanation in MYSQL DB:
> http://www.mysql.com/doc/m/y/myisamchk_memory.html
>
> Memory used by MYSQL DB:
> http://www.mysql.com/doc/M/e/Memory_use.html
>
> MYSQL DB Status:
> http://www.mysql.com/doc/S/H/SHOW_STATUS.html
>
> Problems with HARD DISKS and MYSQL DB:
> http://www.mysql.com/doc/D/i/Disk_issues.html
>
> Have fun,
>
> Rom
> ----- Original Message -----
> From: [ rswfire ] <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 17, 2001 2:09 PM
> Subject: [PHP] MySQL Disk Space Usage
>
>
> Is it possible to find out how much disk space a particular number of rows
> in a table takes up?? If you have an answer, please email me directly.
> Thank you!!!!!!
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
