MySQL统计数据库大小

select 
concat(truncate(sum(data_length)/1024/1024,2),'mb') as data_size, 
concat(truncate(sum(max_data_length)/1024/1024,2),'mb') as max_data_size, 
concat(truncate(sum(data_free)/1024/1024,2),'mb') as data_free, 
concat(truncate(sum(index_length)/1024/1024,2),'mb') as index_size
from information_schema.tables where table_schema = 'contract_ggpt';

  

原文地址:https://www.cnblogs.com/lixx/p/8478977.html