List out one database, and each tables size in detail

mysql_table_size.sql

SELECT table_name, table_rows, data_length, index_length, 
round(((data_length + index_length) / 1024 / 1024),2) "Size in MB"
FROM information_schema.TABLES WHERE table_schema = "schema_name";

-- thanks to http://www.mkyong.com/mysql/how-to-calculate-the-mysql-database-size/