SELECT    table_schema AS "数据库",    sum(table_rows) AS "记录数",    sum(        TRUNCATE (data_length / 1024 / 1024, 2)    ) AS "数据容量(MB)",    sum(        TRUNCATE (index_length / 1024 / 1024, 2)    ) AS "索引容量(MB)"FROM    information_schema. TABLESGROUP BY    table_schemaORDER BY    sum(data_length) DESC,    sum(index_length) DESC;

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. TABLESORDER BY    data_length DESC,    index_length DESC;

SELECT    table_schema AS "数据库",    sum(table_rows) AS "记录数",    sum(        TRUNCATE (data_length / 1024 / 1024, 2)    ) AS "数据容量(MB)",    sum(        TRUNCATE (index_length / 1024 / 1024, 2)    ) AS "索引容量(MB)"FROM    information_schema.tables where table_schema = "your_table_name";

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 = "指定的库名" ORDER BY    data_length DESC,    index_length DESC;