MySQL Database and Table Size Query

db_size.sql

SELECT table_schema "DB Name", 
Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size (MB)" 
FROM   information_schema.tables 
GROUP  BY table_schema; 

SELECT table_name
, round(((table_rows) / 1024 / 1024), 2) as "Row Count (mil)"   
, round(((data_length) / 1024 / 1024), 2) as "Data Size (MB)"   
, round(((index_length) / 1024 / 1024), 2) as "Index Size (MB)"   
, round(((data_length + index_length) / 1024 / 1024), 2) as "Table Size (MB)"
FROM information_schema.TABLES  
WHERE table_schema = "DATABASE_NAME"  
ORDER BY round(((data_length + index_length) / 1024 / 1024), 2) DESC;