Page 1 of 1

How does PHPMyAdmin calculate space taken and wasted?

Posted: Wed Mar 05, 2003 10:40 am
by puckeye
Hi all,

I'm trying to figure out how the makers of PHPMyAdmin came up with the equations of the space taken/wasted in their program?

Why I want those equations is so that I can create a PHP module to Optimize the table when the waste is more then XXXXX bytes or maybe even when the waste reaches XX% of total space.

I have MySQL 3.23.41, PHP 4.0.6 on one server
and
MySQL 3.23.36, PHP 4.1.2 on another.

Thansk all

Posted: Tue Mar 11, 2003 12:10 pm
by puckeye
Doesn't anybody here knows how to ask MySQL for the databases and tables actual size and if there's any wasted space?

I don't need the exact code from PHPMyAdmin (I could have taken it directly from the coding on our server) but more a simple "how-to" exemple.

I guess I'll have to scrounge the code to find out what I need.

Thanks anyway.