Fiko Borizqy
Fiko Borizqy

Fiko Borizqy

MySQL: How to get database sizes

Fiko Borizqy
·Jun 21, 2022·

1 min read

Subscribe to my newsletter and never miss my upcoming articles

MySQL provides metadata of the database itself, basically just run this on your query. Don't forget to replace database name with yourown database name.

SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "replace_with_your_database_name"
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;

Credit, thanks to: https://chartio.com/resources/tutorials/how-to-get-the-size-of-a-table-in-mysql/

 
Share this