How to check MySQL databases size

How to check MySQL databases size

Here is a simple select that will give you the size for each databases in your MySQL instance

SELECT table_schema "db_name", 

sum(data_length+index_length) /1024/1024 "db_size in Mb"

FROM information_schema.tables

GROUP BY 1;