Re: MySQL Disk Space Usage
| From: | [ rswfire ] | Date: | Wed, 17 Jan 2001 19:42:41 +0000 |
| Subject: | Re: MySQL Disk Space Usage | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-35123@lists.php.net to get a copy of this message | ||
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 <php@diffdev.com>
To: [ rswfire ] <rswfire@hotmail.com>; <php-general@lists.php.net>
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 ] <rswfire@hotmail.com>
> To: <php-general@lists.php.net>
> 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!!!!!!
>
>
>