Zabbix 监控 MySQL 解决告警 Buffer pool utilization is too low

Zabbix 解决告警记录

1.环境介绍

将 MySQL 接入 Zabbix 后触发了一个告警

MySQL: Buffer pool utilization is too low (less 50% for 5m)

The buffer pool utilization is less than 50% in the last 5 minutes. This means that there is a lot of unused RAM allocated for the buffer pool, which you can easily reallocate at the moment.
#缓冲池利用率太低

2.解决此告警

$ vim /usr/local/mysql/conf/my.cnf
#默认安装路径在 /etc/my.cnf

innodb_buffer_pool_size = 128M
#降低此值即可解决利用率太低的告警

Over~

1740 0 2020-10-11

打赏一下，各位朋友请随意打赏！

×

如果觉得我的文章对你有用，请随意赞赏

取消