All posts tagged in: MySQL table size

article image

How to get size of each table of a MySQL Database

20

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 ..

Menu Title