[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!!
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]
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]
Re: [PHP] 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 ] [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]