mysql中对数据库的大小的查看

查看库中表的大小

select table_name, concat(truncate(data_length/1024/1024,2),' mb') as data_size,
concat(truncate(index_length/1024/1024,2),' mb') as index_size
from information_schema.tables where table_schema = 'test'
group by table_name
order by data_length desc;

注意将table_schema中替换为自己的库的名称

查看各个库的大小

 use information_schema;
 select TABLE_SCHEMA,concat(round(sum(data_length/1024/1024),2),'MB') as data from tables group by TABLE_SCHEMA;
 
select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables ;