查看MySQL中各表所占磁盘大小语句:
例如:
use information_schema;
select table_name,concat(round(DATA_LENGTH/1024/1024/1024,2),'GB') as data
from TABLES
where table_schema='analysis'
order by concat(round(DATA_LENGTH/1024/1024/1024,2),'GB')
desc;
-- 其中analysis为表所在的数据库名,根据表所占磁盘大小降序排列