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
) `Size in MB`
FROM information_schema.TABLES
data_length + index_length
LIMIT 0, 30


You may also like...

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