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 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
> > To: [ rswfire ] <[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]
