Determine free and occupied size of Tables and Database into MySQL

In this post, I provide two different scripts to find free and occupied size of Table and Database of MySQL.

This script is very useful for DBA to identify the size of tables and databases.

If you find more free spaced than DBA has to take steps to recover all that free space. This is mostly happening with InnoDB MVCC architecture.

Please read interesting about MVCC:

Below is a script:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz