作者：真心AI你fd_352 | 来源：互联网 | 2014-06-09 00:50
查询mysql中所有数据库占用磁盘空间大小和单个库中所有表的大小Sql代码www.2cto.comselectTABLE_NAME,concat(truncate(data_length/1024/1024,2),'MB')asdata_size,concat(truncate(i...
查询mysql中所有
数据库占用磁盘空间大小和单个库中所有表的大小
Sql代码 www.2cto.com
select TABLE_NAME, concat(truncate(data_length/1024/1024,2),&＃39; MB&＃39;) as data_size,
concat(truncate(index_length/1024/1024,2),&＃39; MB&＃39;) as index_size
from information_schema.tables where TABLE_SCHEMA = &＃39;wxsj_user&＃39;
group by TABLE_NAME
order by data_length desc;
select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,2),&＃39; MB&＃39;) as data_size,
concat(truncate(sum(index_length)/1024/1024,2),&＃39;MB&＃39;) as index_size
from information_schema.tables
group by TABLE_SCHEMA
order by data_length desc;
京公网安备 11010802041100号