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)` 
FROM
    information_schema.TABLES 
GROUP BY
    table_schema 
ORDER BYdata_lengthDESC