Shows all the tables with their sizes in MB with descending order
SELECT
table_name AS `Table`,
round(((data_length + index_length) / 1024 / 1024), 2) AS MB_size
FROM information_schema.TABLES
WHERE table_schema = "database_name"
order by MB_size desc by Valeri Tandilashvili
3 years ago