View Full Version : Size in KB of MySQL table

06-14-2006, 06:37 PM
What's the best way to find the size in KB of a MYSQL table?

I was thinking maybe there was some shell scripting I could execute with PHP's exec() command, to find the size of any given table. I don;t see any existing PHP functions (http://us3.php.net/manual/en/ref.mysql.php) that will perform this task for me.

Any ideas?

Edit: And if anyone knows the shell required here, could you please post it? Thanks..

06-14-2006, 06:59 PM
use SHOW TABLE STATUS mysql statement in mysql_query()