MySql: Check each database size running in mysql.

Source URL: http://stackoverflow.com/questions/1733507/how-to-get-size-of-mysql-database

SELECT table_schema                                        "DB Name", 

   Round(Sum(data_length + index_length) / 1024 / 1024, 1) AS "DB Size in MB" 

FROM   information_schema.tables 

GROUP  BY table_schema

ORDER BY Round(Sum(data_length + index_length) / 1024 / 1024, 1) DESC;

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;