Home / Blog / Post
Get Size Of Tables In Mysql
Added on 30th April 2019 in Snippet

This is a small snippet to quickly see the sizes of all tables within a mysql database and ordering them in size descending. This is helpfull when trying to tidy existing databases and removing excess data.

SELECT 
   table_schema as `Database`, 
   table_name AS `Table`, 
   round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Hi there, I am christopher shaw, a software developer form South Yorkshire, England.

I love tinkering with all things tech, and opened this website as a web presence for myself and a place to keep my notes and snippets. Hopefully you will find something here to help

Christopher Shaw