RE: [PHP] Amount of data in the database
| From: | Timothy Hitchens \(HiTCHO\) | Date: | Sun, 12 Jan 2003 06:17:11 +0000 |
| Subject: | RE: [PHP] Amount of data in the database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131312@lists.php.net to get a copy of this message | ||
I haven't seen a way to get the size of an individual record.
What about using the max size of the fields in that table against number
of records eg:
255 char = x bytes etc etc = 156KB per record max
Timothy Hitchens (HiTCHO)
Open Platform Consulting
e-mail: tim@hitcho.com.au
> -----Original Message-----
> From: Denis L. Menezes [mailto:menezesd@singnet.com.sg]
> Sent: Sunday, 12 January 2003 4:10 PM
> To: hitcho@php.net; 'PHP general list'
> Subject: Re: [PHP] Amount of data in the database
>
>
> Thanks Timothy.
>
> I want to find the amount of data for each member in the
> database using PHP and displaying in a web page. I know how
> to query records of a member and also know to display. Only I
> need to know the command for finding the size(in bytes or kb)
> for each of these records :Something like seeing the file
> sizes of each email in hotmail.
>
>
> Thanks
> Denis
> ----- Original Message -----
> From: "Timothy Hitchens (HiTCHO)" <hitcho@php.net>
> To: "'Denis L. Menezes'" <menezesd@singnet.com.sg>; "'PHP
> general list'" <php-general@lists.php.net>
> Sent: Sunday, January 12, 2003 1:29 PM
> Subject: RE: [PHP] Amount of data in the database
>
>
> > Give this a go.. for each of the databases use:
> >
> > SHOW TABLE STATUS FROM xxxxxx;
> >
> > That will return a huge amount of size etc data!!
> >
> >
> >
> > Timothy Hitchens (HiTCHO)
> > Open Platform Consulting
> > e-mail: tim@hitcho.com.au
> >
> > > -----Original Message-----
> > > From: Denis L. Menezes [mailto:menezesd@singnet.com.sg]
> > > Sent: Sunday, 12 January 2003 2:58 PM
> > > To: PHP general list
> > > Subject: [PHP] Amount of data in the database
> > >
> > >
> > > Hello friends.
> > >
> > > I have a need for checking how much data(in kb) exists of each of
> > > the user members in the MySQL so that when they upload
> more data I
> > > can restrict/warn them of the amount of data they have on
> the server
> > > at present.
> > >
> > > can anyone please tell me how to check the amount of data on the
> > > mysql for each record?
> > >
> > > thanks very much
> > > Denis
> > >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>