重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 快速查看MySQL下数据库月度增长趋势sql语句 [打印本页]

作者: jiawang 时间: 2026-1-21 17:39
标题: 快速查看MySQL下数据库月度增长趋势sql语句
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;