Home >Database >Mysql Tutorial >Detailed example of how to check the table size in MySql
When the database takes up a lot of space, you can use the following statement to find a table with a large amount of data
SELECT TABLE_NAME ,round((DATA_LENGTH/1024/1024),2) 'DATA_SIZE(M)' ,round((INDEX_LENGTH/1024/1024),2) 'INDEX_SIZE(M)' ,AVG_ROW_LENGTH ,MAX_DATA_LENGTH ,CREATE_TIMEFROM information_schema.tablesWHERE TABLE_SCHEMA ='库名'ORDER BY 2 desc;
Running results
The above is the detailed content of Detailed example of how to check the table size in MySql. For more information, please follow other related articles on the PHP Chinese website!