Bioinformatics Analyst at Seven Bridges & PhD Student at METU

Get Size of MySQL Databases

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;