How to show the disk space used by MySQL tables? Posted on February 4, 2019 by fabricetriboix Connect to your MySQL server and run the following: mysql> select table_name, round(((data_length + index_length) / (1024 * 1024)), 2) as `Size in MB` from information_schema.tables where table_schema = 'YOUR_DB_NAME' order by `Size in MB`;