zabbix2.4.2 Combat Monitoring mysql5.6 performance

1. Search online A lot of information, very few monitoring mysql5.6, through their own practice, easy to achieve, share to everyone.

2. Monitored side settings

2.1 Setting up user and password to monitor MySQL

Mysql> GRANT PROCESS on * * to ' zabbix ' @ ' localhost ' identified by ' Zabbix ';

mysql> Flush privileges;

2.2 Configuring the My.cnf file (not added)

#vi/etc/my.cnf

[MySQL]

User=zabbix

Password=zabbix

Why configure MY.CNF, is due to mysql5.6 security issues

2.3 Adding monitoring items

#vi/usr/local/zabbix_agent/etc/zabbix_agentd.conf

Userparameter=mysql[*],mysql-h localhost-p 3306-e "show Global Status" |grep "\<$1\>" |cut-f2

3. Monitoring Terminal settings

3.1 Importing the zabbix_mysql5.6 of an attachment template

3.2 Adding templates to monitored hosts

3.3 Restart Zabbix_server

3.4 Waiting Results

This article is from the "Hanyun.fang" blog, make sure to keep this source http://hanyun.blog.51cto.com/1060170/1596049

zabbix2.4.2 Combat Monitoring mysql5.6 performance