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