查看当前的数据和索引的总大小
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;
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;