Get Table Overhead and Size from MySQL

Databases
1

How do I get the overhead and size of each table in a MySQL database. I’m implementing functionality into an application I’m developing to allow users to optimize tables with large overheads, so I need to be able to show the size of the table, and the overhead (much like PHPMyAdmin does when viewing the structure of a database).

Thanks

2

do a search in the mysql forum for posts by me with the word “overhead” in them.

3

I had already done all that kind of stuff. By looking at phpmyadmin’s source code, I found that it seems the overhead is simply the Data_free field returned by SHOW TABLE STATUS.

http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

Correct me if I’m wrong.

4
5