mysql查看数据库的存储大小 查看mysql内存大小

2、查看所有库：

select TABLE_SCHEMA,
concat(truncate(sum(data_length)/1024/1024,2),’ MB’) as data_size,
concat(truncate(sum(index_length)/1024/1024,2),‘MB’) as index_size
from information_schema.tables group by TABLE_SCHEMA order by data_length desc;

3、查看单个库

select concat(truncate(sum(data_length)/1024/1024,2),‘MB’) as data_size,