MySQL Snippets

mysql-snippets.sql

-- Table sizes, ordered by Database
SELECT table_schema AS "Database",
        table_name AS "Table",
        ROUND(((data_length) / 1024 / 1024), 2) AS "Data (MB)",
        ROUND(((index_length) / 1024 / 1024), 2) AS "Indexes (MB)", 
        ROUND(((data_length + index_length) / 1024 / 1024), 2) "Total (MB)"
FROM information_schema.TABLES
WHERE table_schema NOT IN ("information_schema", "mysql")
ORDER BY table_schema ASC, table_name ASC;