查看当前的数据和索引的总大小

select round(sum(data_length+index_length)/1024/1024)
as total_mb,
round(sum(data_length)/1024/1024) as data_mb,
round(sum(index_length)/1024/1024) as index_mnb
from information_schema.tables;
 
posted @ 2018-08-01 14:13  屠魔的少年  阅读(421)  评论(0)    收藏  举报