监控MySQL - 监控相关

#编写mysql的zabbix配置文件
	vim /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
	#内容
	UserParameter=mysql.ping[*], HOME=/etc/zabbix mysqladmin ping
	UserParameter=mysql.get_status_variables[*],HOME=/etc/zabbix mysql -sNX -e "show global status"
	UserParameter=mysql.version[*],HOME=/etc/zabbix mysqladmin version
	UserParameter=mysql.uptime,HOME=/etc/zabbix mysqladmin status | cut -f2 -d ":" | cut -f1 -d "T" | tr -d " "
	UserParameter=mysql.db.discovery[*],HOME=/etc/zabbix mysql -sN -e "show databases"
	UserParameter=mysql.dbsize[*], HOME=/etc/zabbix mysql -sN -e "SELECT SUM(DATA_LENGTH + INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='zabbix'"
	UserParameter=mysql.replication.discovery[*], HOME=/etc/zabbix  mysql -sNX -e "show slave status"
	UserParameter=mysql.slave_status[*], HOME=/etc/zabbix  mysql -sNX -e "show slave status"

---
#编写zabbix链接mysql的配置文件
	vim /etc/zabbix/.my.cnf
	#内容
	[client]
	host=localhost
	user=monitorQuery
	password=xxxxxxxx
	[mysqladmin]
	host=localhost
	user=monitorQuery
	password=xxxxxxxx

---
#数据库创建监控账号
	GRANT USAGE,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'monitorQuery'@'%' IDENTIFIED BY 'xxxxxxxx';

flush privileges;

---
#重启zabbix-agent
	systemctl restart zabbix-agent
	
---
#关联模板
	
![](/media//202112/2021-12-20111752434968.png)