Re: MySQL Disk Space Usage

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 ] <rswfire@hotmail.com> To: <php-general@lists.php.net> 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 <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!!!!!! > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net