MySQL統計データベースサイズ

477 ワード

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