一点一滴努力,满仓满谷收成

1、统计某一个库中各表空间占用多少MB

use information_schema;

SELECT TABLE_NAME,
       CONCAT(TRUNCATE(DATA_LENGTH / 1024 / 1024, 2), ' mb') AS DATA_SIZE,
       CONCAT(TRUNCATE(INDEX_LENGTH / 1024 / 1024, 2), ' mb') AS INDEX_SIZE
  FROM INFORMATION_SCHEMA.TABLES
 WHERE TABLE_SCHEMA = 'zabbix'
 GROUP BY TABLE_NAME
 ORDER BY DATA_LENGTH DESC;

阅读全文…