MySql如何查看表大小的实例详解

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;