MySQL goodies

gistfile1.sql

# Total size of data + indexes for *ALL* DBs
SELECT table_schema "DB Name", ROUND(SUM(data_length) / 1024 / 1024, 2) "Data size (MB)", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) 
"Data + Indexes size (MB)" FROM information_schema.TABLES GROUP BY table_schema ;

# Total size of data + indexes for *ALL* Tables in a DB
SELECT TABLE_NAME, table_rows, data_length, index_length, round(((data_length + index_length) / 1024 / 1024),2) "Total size (MB)"
FROM information_schema.TABLES WHERE table_schema = "db_name";