Linux查看MYSQL数据库容量大小命令

mysql> use information_schema;
mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),‘MB‘) as data_mb from TABLES;

mysql> use information_schema;
mysql> SELECT table_schema,CONCAT(ROUND(SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024,2),‘MB‘) AS total_mb FROM TABLES GROUP BY table_schema;  

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

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
order by data_length desc, index_length desc;