This the query that displays MySQL tables sizes in MB:
SELECT table_schema "DM NAME", ROUND( SUM( data_length + index_length ) /1024 /1024, 1 ) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema LIMIT 0 , 30
This the query that displays MySQL tables sizes in MB:
SELECT table_schema "DM NAME", ROUND( SUM( data_length + index_length ) /1024 /1024, 1 ) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema LIMIT 0 , 30