650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/8B/77/wKioL1hPRkDQK0lFAAA8XQsvMcc784.png-wh_500x0-wm_3 -wmp_4-s_1746572393.png "title="}t]fogwc86{2{96~0@4me9r.png "alt=" Wkiol1hprkdqk0lfaaa8xqsvmcc784.png-wh_50 "/>
When MySQL is down, Zabbix displays the following results
650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8B/77/wKioL1hPRweCfcl2AAA6PKF9JfA282.png-wh_500x0-wm_3 -wmp_4-s_4191731075.png "title=" 1.png "alt=" wkiol1hprwecfcl2aaa6pkf9jfa282.png-wh_50 "/>650) this.width=650;" Src= "http://s2.51cto.com/wyfs02/M00/8B/7B/wKiom1hPR1jgIdJ4AAAavvbVrUc233.png-wh_500x0-wm_3-wmp_4-s_3882009054. PNG "title=" 3.png "alt=" Wkiom1hpr1jgidj4aaaavvbvruc233.png-wh_50 "/>
Using a sequence of commands from the Mysqladmin component and retrieving the alive to get the result set, the fetch to return 1 indicates that the MySQL service is on, and returns 0 means that the MySQL service is turned off, but in fact? can return 1 but not return 0, because the mysqladmin command will first error message out, so zabbix-server call when the return is not a pure number, but the string + familiar, Zabbix-server trigger inside cannot recognize
So you can know that mysqladmin in the MySQL service down, the return of the string alarm + number 0, completely trigger the Zabbix alarm conditions, it is necessary to consider other ways to judge.
Search for relevant data telnet is also unable to meet the MySQL down when the alarm triggered by the demand, now with Netstat try
650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8B/77/wKioL1hPSJ6Rxsl1AAAOEEQVSXs707.png-wh_500x0-wm_3 -wmp_4-s_3082425061.png "title=" 4.png "alt=" Wkiol1hpsj6rxsl1aaaoeeqvsxs707.png-wh_50 "/>
Netstat-lntup|grep 3306|grep Mysql|wc|awk ' {print $} '
Mysqladmin Ping in the configuration file | Grep-c alive Change to the above command try
Restart Zabbix_agentd
Found or not, finally found that the netstat was remotely invoked when the failure to execute:
chmod +s/bin/netstat
It worked
This article from "Little Fart Babe" blog, declined reprint!
Zabbix Monitor MySQL down when no alarm resolution method