Mysql 查看数据库、表占用空间、记录数等信息

查看所有数据库的容量

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)',
    sum(
    TRUNCATE ( DATA_FREE / 1024 / 1024, 2 )) AS '碎片占用(MB)' 
FROM
    information_schema.TABLES 
GROUP BY
    table_schema 
ORDER 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)',
    TRUNCATE ( DATA_FREE / 1024 / 1024, 2 ) AS '碎片占用(MB)' 
FROM
    information_schema.TABLES 
WHERE
    table_schema = 'your_db_name'  -- 更改为数据库名
ORDER BY
    data_length DESC,
    index_length DESC;