1mysql> select table_schema, sum((data_length+index_length)/1024/1024) AS MB from information_schema.tables group by 1;
2+--------------------+-----------------+
3| table_schema | MB |
4+--------------------+-----------------+
5| prod | 298025.72448921 |
6| information_schema | 0.00781248 |
7| maatkit | 70.77330779 |
8| mysql | 0.66873168 |
9| test | 4752.31449127 |
10+--------------------+-----------------+
115 rows in set (0.01 sec)
12