Display MySQL tables sizes


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


Any thoughts?

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Loading more content...