How to display the size of all MySQL tables using the command line


Issue the following command if you want to see in Megabytes the size of all MySQL tables from the command line:

SELECT table_name AS “Table”, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS “Size (MB)” FROM information_schema.TABLES WHERE table_schema = “DATABASE_NAME” ORDER BY (data_length + index_length) DESC;

Substitute DATABASE_NAME with the name of your database.


Share this article

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top