Posted about 11 years ago. Visible to the public. Linked content.

List sizes of MySQL databases

Do you wonder which databases are actually taking up how much space but only have one huge ibdata1 in your /var/lib/mysql and the directories inside your mysql data directory don't represent the actual database sizes? This is for you!

Run from a mysql root console:

SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;

This will get you a result like the following:

+----------------------+--------------+ | Database name | Size (MB) | +----------------------+--------------+ | information_schema | 0.00781250 | | mysql | 0.61204815 | | project1_development | 281.59375000 | | project1_test | 7.29687500 | | project2_development | 2.65625000 | | project2_test | 0.15625000 | +----------------------+--------------+

Your development team has a full backlog of feature requests, chores and refactoring coupled with deadlines? We are familiar with that. With our "DevOps as a Service" offering, we support developer teams with infrastructure and operations expertise.

Owner of this card:

Arne Hartherz
Last edit:
almost 8 years ago
by Arne Hartherz
show, calculate, space, consumption
About this deck:
We are makandra and do test-driven, agile Ruby on Rails software development.
License for source code
Posted by Arne Hartherz to makandra dev
This website uses short-lived cookies to improve usability.
Accept or learn more