查询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;