Show Table Sizes

calendar2020-01-21 · 1 min read · mysql mariadb table sizes  ·
Share on: linkedincopy

Use the query below and replace "database_name" with the correct db name.

1SELECT table_name AS "Table",
2ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
3FROM information_schema.TABLES
4WHERE table_schema = "database_name"
5ORDER BY (data_length + index_length) DESC;