mysql 查看 库 表 大小
#查询所有数据的大小
use information_schema;SELECT concat(sum(DATA_LENGTH+INDEX_LENGTH)/(1024*1024),'MB') 库内表大小 FROM TABLES;
#查看指定数据库的大小,比如说:数据库test
use information_schema;
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='test';
查看指定数据库的表的大小,比如说:数据库test 中gaodemap_poi表
use information_schema;
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='win_bizdata' and table_name='gaodemap_poi';