Re: MySQL Disk Space Usage

From: 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!!!!!! > > >

« previous php.general (#35123) next »