Page 1 of 1

how does when get the physical storage space used up by db?

Posted: Sun Dec 31, 2006 5:21 am
by konstandinos
hello folk

ive looked at all the mysql_* functions on php.net, and still can't find what i am looking for.

i would like to get the size (in bytes or mb's or whatever) of a table, and perhaps even the containing database too (but i could just add up the tables for that).

what is the most efficient way to do this?

thanks

Posted: Sun Dec 31, 2006 6:06 am
by onion2k
The SQL you want is:

Code: Select all

show table status