List summary table type and size details.

table_size.sql

SELECT @@hostname, DATABASE() as table_schema, CURDATE() AS today;
SELECT if(length(table_name)>30,concat(left(table_name,28),'..'),table_name) AS table_name,
 engine,row_format as format, table_rows, avg_row_length as avg_row,
 round((data_length+index_length)/1024/1024,2) as total_mb, 
 round((data_length)/1024/1024,2) as data_mb, 
 round((index_length)/1024/1024,2) as index_mb
FROM information_schema.tables 
WHERE table_schema=DATABASE()
ORDER BY 6 DESC
LIMIT 15;