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:

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from