SELECT table_schema asDatabase
, table_name ASTable
, round(((data_length + index_length) / 1024 / 1024), 2)Size in MB
FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;
SELECT table_schema asDatabase
, table_name ASTable
, round(((data_length + index_length) / 1024 / 1024), 2)Size in MB
FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;