Get Size of MySQL Databases
By Güngör Budak
- One minute read - 39 wordsUse 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;