Posted over 10 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 | +----------------------+--------------+

Flaky tests are tests that sometimes fail for no obvious reason. They are the plague of many end-to-end (E2E) test suites that automate the browser through tools like Capybara and Selenium.

Join our free training event and learn to fix any flaky test suite, even in large legacy applications.

Owner of this card:

Arne Hartherz
Last edit:
about 7 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