Get Size of MySQL Databases

Share Tweet

Use below query in MySQL command prompt to get a table of databases and their sizes in MB.

SELECT table_schema "DB Name", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema;
Share Tweet


Please start a discussion down below or send me an email!