Get database size in phpMyAdmin

It looks like phpMyAdmin doesn’t include a way to see how much space takes the MySQL database. I found that a bit weird, but hey, if phpMyAdmin doesn’t do it, let’s cut to the chase and go SQL!

The most straightforward way to get your database size from phpMyAdmin is the following SQL query:

SELECT table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;

Originally from the MySQL forums.

14 thoughts on “Get database size in phpMyAdmin”

  1. there is a way, go to databases then under the database list click “enable statistics”, though the method you describe is cool. i like getting my hands dirty

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

  2. Ah! I ran into an issue today of my own mysql db being overloaded and turned read-only by OVH. Apparently newer versions of phpMyAdmin show the table size in the table list, meaning the technique this article is not all that useful anymore. :)

  3. Pingback: Indigoblue

Leave a Reply

Your email address will not be published. Required fields are marked *