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.