Re: Mysql DB / Table Disk Usage

I can see only one good way: dump database and install it at your devel-box, then use 'du -sh ...' > Agreed - I'd be hardpressed to see it done. Of course, they might have a sucky > admin that chmod 777 the data directory... > > --Joe > > On Sat, Dec 23, 2000 at 07:49:52PM +0100, Cynic wrote: > > > > >Other than that You would have to cycle through every table > > >and add up all the bytes (which would suck). > > > > Besides, it would be way off the real numbers. > > Reasons: > > 1) When you delete data from atable, the RDBMS just _marks_ the > > space the data occupied as unused, ready to get overwritten > > with the next insert insert. But it still takes space. You > > would have tu (I hope it's called that) 'pack' the table. > > So, if you have 500MB table with 5% of deleted data, thats > > 25MB of space you will slip. > > 2) You haven't taken into account the index file counterpart > > every data file has. > > > > sizeof( $data ) < sizeof( $files ) > > > > > > At 19:25 23.12. 2000, Joe Stump wrote the following: > > -------------------------------------------------------------- > > >MySQL is VERY picky about who it lets into its data directory. I don't think > > >there is a good way to do it. I would "man mysqladmin" and see if that might > > >be able to do it. Other than that You would have to cycle through every table > > >and add up all the bytes (which would suck). > > > > > >--Joe > > > > > >On Sat, Dec 23, 2000 at 06:15:48PM -0000, Cybercandy Ltd wrote: > > >> I've search the archives and haven't found an answer to this question. > > >> > > >> Is there anyway in php and/or mySQL to report on the amount of disk space > > >> that a > > >> database and/or a table is occupying. > > >> > > >> Bearing in my that because I'm using an ISP rather than my own webserver I > > >> don't think > > >> I have access to the database file itself. > > >> > > >> > > >> > > >> Allan Goacher > > >> www.cybercandy.co.uk > > >> > > >> > > >> > > >> -- > > >> 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 > > > > > >--- > > >Joe Stump > > >PHP Programmer > > >www.Care2.com > > > > > > > > >-- > > >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 > > ------end of quote------ > > > > > > > > ____________________________________________________________ > > Cynic: > > > > A member of a group of ancient Greek philosophers who taught > > that virtue constitutes happiness and that self control is > > the essential part of virtue. > > > > cynic@mail.cz > > > > > > --- > Joe Stump > PHP Programmer > www.Care2.com > > > -- > 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 > > > -- Sincerely yours, -Michael