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
WHERE
    table_schema = 'mydb'
    AND TABLE_NAME = 'mytable'
ORDER BY
    data_length DESC,
    index_length DESC;