zabbix3mysql_zabbix3监控mysql性能状态

文章目录

[隐藏]

配置zabbix目录

修改mysql监控的的配置

修改my.cnf 配置

如果被监控的主机上已经安装好了mysql&＃xff0c;在安装zabbix-agent的时候就会自动创建一个userparameter_mysql.conf

配置zabbix目录

vim /etc/zabbix/zabbix_agentd.conf #取消注释,没有则创建一个 Include&＃61;/etc/zabbix/zabbix_agentd.d/

修改mysql监控的的配置

vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf UserParameter&＃61;mysql.status[*],echo "show global status where Variable_name&＃61;&＃39;$1&＃39;;" | HOME&＃61;/var/lib/zabbix mysql -N | awk &＃39;{print $$2}&＃39; UserParameter&＃61;mysql.size[*],echo "select sum($(case "$3" in both|"") echo "data_length&＃43;index_length";; data|index) echo "$3_length";; free) echo "data_free";; esac)) from information_schema.tables$([[ "$1" &＃61; "all" || ! "$1" ]] || echo " where table_schema&＃61;&＃39;$1&＃39;")$([[ "$2" &＃61; "all" || ! "$2" ]] || echo "and table_name&＃61;&＃39;$2&＃39;");" | HOME&＃61;/var/lib/zabbix mysql -N UserParameter&＃61;mysql.ping,HOME&＃61;/var/lib/zabbix mysqladmin ping | grep -c alive UserParameter&＃61;mysql.version,mysql -V

修改my.cnf 配置

# Zabbix Agent ;注意sock文件路径 [mysql] host &＃61; localhost user &＃61; zabbix password &＃61; 密码 socket &＃61; /var/run/mysqld/mysqld.sock [mysqladmin] host &＃61; localhost user &＃61; zabbix password &＃61; 密码 socket &＃61; /var/run/mysqld/mysqld.sock

为被监控的主机添加mysql模版

添加mysql监控的模版

查看获取的mysql数据

原文出处&＃xff1a;菜鸟HOW站长 -> https://www.cnhzz.com/zabbix-mysql/