MySQL: Table Size States

mysql_table_sizes.sql

-- Get Table Sizes
SELECT NOW(),
       TABLE_SCHEMA,
       TABLE_NAME,
       ENGINE,
       TABLE_ROWS,
       DATA_LENGTH / 1024 / 1024,
       INDEX_LENGTH / 1024 / 1024,
       DATA_FREE,
       AUTO_INCREMENT
FROM   INFORMATION_SCHEMA.TABLES;

-- Sizes grouped by schema
SELECT NOW(),
       TABLE_SCHEMA,
       ENGINE,
       SUM(TABLE_ROWS),
       SUM(DATA_LENGTH / 1024 / 1024),
       SUM(INDEX_LENGTH / 1024 / 1024),
       SUM(DATA_FREE)
FROM   INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA;