Re: MySQL Disk Space Usage

Thankz Larry... I actually thought of that as a solution, but I don't know I would determine the disk space usage of blob types, which I do use quite frequently and I need the results to be extremely accurate. I was hopeful that there was a function available to do this, but apparently not. Thanks again.. ----- Original Message ----- From: Larry Hotchkiss <lhotch@unicap.com> To: <rswfire@hotmail.com> Sent: Wednesday, January 17, 2001 2:42 PM Subject: RE: [PHP] MySQL Disk Space Usage > I believe you are going to need to take a look at the mysql manual a bit > closer to do this. How much space a user in a table takes up is based on > the type of field (ie varchar, int etc etc). If you know what each column > in a row is the manual outlines the space consumption of various data types > and then you can count rows and do the math per user. > > Larry H. > > On Wednesday, January 17, 2001 1:43 PM, wrote: > > 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>; <> > > 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 > > > >