MySQL Status, Database and Table Sizes

sql

SHOW FULL PROCESSLIST;


SHOW ENGINE INNODB STATUS;


SELECT table_schema "db", SUM(data_length + index_length) / 1024 / 1024 
"mb" FROM information_schema.TABLES GROUP BY table_schema ORDER BY mb DESC;


SELECT TABLE_NAME, table_rows, data_length, index_length, 
round(((data_length + index_length) / 1024 / 1024), 2) "mb"
FROM information_schema.TABLES ORDER BY mb DESC;