mysql的告警指标_Prometheus监控MySQL告警规则

alert: MySQL is down

expr: mysql_up == 0

for: 1m

labels:

severity: critical

annotations:

summary: “Instance { { $labels.instance }} MySQL is down”

description: “MySQL database is down. This requires immediate action!”

alert: open files high

expr: mysql_global_status_innodb_num_open_files > (mysql_global_variables_open_files_limit) * 0.75

for: 1m

labels:

severity: warning

annotations:

summary: “Instance { { $labels.instance }} open files high”

description: “Open files is high. Please consider increasing open_files_limit.”

alert: Read buffer size is bigger than max. allowed packet size

expr: mysql_global_variables_read_buffer_size > mysql_global_variables_slave_max_allowed_packet

for: 1m

labels:

severity: warning

annotations:

summary: “Instance { { $labels.instance }} Read buffer size is bigger than max. allowed packet size”

description: “Read buffer size (read_buffer_size) is bigger than max. allowed packet size (max_allowed_packet).This can break your replication.”

alert: Sort buffer possibly missconfigured

expr: mysql_global_variables_innodb_sort_buffer_size <2561024 or mysql_global_variables_read_buffer_size > 41024*1024

for: 1m

labels:

severity: warning

annotations:

summary: “Instance { { $labels.instance }} Sort buffer possibly missconfigured”

description: “Sort buffer size is either too big or too small. A good value for sort_buffer_size is between 256k and 4M.”

alert: Thread stack size is too small

expr: mysql_global_variables_thread_stack <196608

for: 1m

labels:

severity: warning

annotations:

summary: “Instance { { $labels.instance }} Thread stack size is too small”

description: “Thread stack size is too small. Th

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值