[命令及语法] 快速查看MySQL下数据库月度增长趋势sql语句

[复制链接]

jiawang

电梯直达

楼主

发表于 2026-1-21 17:39:36 | 只看该作者回帖奖励

|倒序浏览 |阅读模式

SELECT
  table_schema AS db_name,
  CONCAT(ROUND(SUM(data_length)/1024/1024/1024, 2), 'GB') AS current_size,
  CONCAT(ROUND(SUM(data_length - (SELECT data_length FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = t1.table_schema AND create_time >= DATE_SUB(NOW(), INTERVAL 1 MONTH)))/1024/1024/1024, 2), 'GB') AS month_growth
FROM INFORMATION_SCHEMA.TABLES t1
WHERE table_schema NOT IN ('mysql', 'information_schema', 'performance_schema', 'sys')
GROUP BY table_schema;