Zabbix监控MYSQL服务器性能_zabbix mysql进程负载(cpu、内存)和存活监控

zabbix server主机设定mysql

[root@zabbix-server ~]# mkdir /var/lib/zabbix

[root@zabbix-server ~]# cd /var/lib/zabbix/

[root@zabbix-server zabbix]# vim .my.cnf

[mysql]
host = localhost
user = root
password = redhat
socket = /var/lib/mysql/mysql.sock

[mysqladmin]
host = localhost
user = root
password = redhat
socket = /var/lib/mysql/mysql.sock

[root@zabbix-server zabbix]# systemctl restart zabbix-agent

zabbix server主机添加DB MYSQL模板并更新

所有主机-->Zabbix server -->模板-->选择Template DB MySQ-->添加-->更新

查看zabbix server的MYSQL图形