Get Table Overhead and Size from MySQL

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).


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

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.

Correct me if I’m wrong.