mysql 列出所数据最多的5张数据表

SELECT 
    TABLE_SCHEMA as `Database`,
    TABLE_NAME as `Table`,
    TABLE_ROWS as `Rows`
FROM 
    information_schema.TABLES
ORDER BY 
    TABLE_ROWS DESC
LIMIT 5;

mysql 列出所占用存储和索引空间最多的5张数据表

SELECT 
    TABLE_NAME AS 表名,
    ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS 表大小_MB,
    ROUND(DATA_LENGTH / 1024 / 1024, 2) AS 数据大小_MB,
    ROUND(INDEX_LENGTH / 1024 / 1024, 2) AS 索引大小_MB
FROM 
    information_schema.TABLES
WHERE 
    TABLE_SCHEMA = 'table_name_xxx'
ORDER BY 
    (DATA_LENGTH + INDEX_LENGTH) DESC LIMIT 5;
    ```