mysql查看表容量

SELECT 
    table_schema AS '数据库', 
    table_name AS '表名', 
    table_rows AS '记录数', 
    TRUNCATE ( data_length / 1024 / 1024, 2 ) AS '数据容量(MB)', 
    TRUNCATE ( index_length / 1024 / 1024, 2 ) AS '索引容量(MB)'  
FROM 
    information_schema.TABLES  
ORDER BY 
    data_length DESC, 
    index_length DESC;

记录SQL