Calculate size of Mysql databases with SQL command

Home > Developers help > Server Administration > Mysql > Calculate size of Mysql databases with SQL command

Here is SQL command you should use, when you need to calculate size of databases on your Mysql server directly from mysql console:
 
SELECT table_schema "DB Name", 
sum( data_length + index_length ) / 1024 / 
1024 "DB Size in MB", 
sum( data_free )/ 1024 / 1024 "Free Space in MB" 
FROM information_schema.TABLES 
GROUP BY table_schema ;
 
Enjoy!
Updated:

Other Articles

×