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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
konstandinos
Forum Commoner
Posts: 68
Joined: Wed Oct 04, 2006 4:20 am

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

Post 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
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post by onion2k »

The SQL you want is:

Code: Select all

show table status
Post Reply