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


Related Post