How To List MySQL Table Sizes in MB

mysql-tbl-sizes.sql

-- Here’s a handy script to list your MySQL table sizes in MB.  
SET @table_schema = '{YOUR_SCHEMA_NAME}'; -- replace with your schema name

SELECT table_name AS "Tables", 
ROUND(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" 
FROM information_schema.TABLES 
WHERE table_schema = @table_schema
ORDER BY (data_length + index_length) DESC;