Menu Title

How to get size of each table of a MySQL Database

This SQL query provides you with list of all tables with largest size in a MySQL database that is executed.

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;
LIMIT 0, 30

 

You may also like...

Thank you for visiting us. To continue receiving updates, please Subscribe to our Social Media Channels.