hwy-zh-gz-gauss-KingdeeFinance 磁盘空间占用过大,当前总空间占用7200G,是否可清理
磁盘空间占用统计sql:
select
table_schema as 数据库,
table_name as 表名,
table_rows as 记录数,
truncate(data_length/1024/1024/1024, 2) as 数据容量(GB),
truncate(index_length/1024/1024/1024, 2) as 索引容量(GB),
truncate(data_free/1024/1024/1024,2) as 碎片容量(GB),
truncate((data_length+index_length+data_free)/1024/1024/1024,2) as 总容量(GB)
from information_schema.tables
order by data_length desc, index_length desc;


