|
Supervision de MySQL avec Zabbix |
Configuration file misc/conf/zabbix_agentd.conf contains list of parameters that can be used for monitoring of MySQL.
### Set of parameter for monitoring MySQL server (v3.23.42 and later)
### Change -u and add -p if required
UserParameter=mysql[ping],mysqladmin -uroot ping|grep alive|wc -l
UserParameter=mysql[uptime],mysqladmin -uroot status|cut f2 -d”:”|cut -f1 -d”T”
UserParameter=mysql[threads],mysqladmin -uroot status|cut f3 -d”:”|cut -f1 -d”Q”
UserParameter=mysql[questions],mysqladmin -uroot status|cut f4 -d”:”|cut -f1 -d”S”
UserParameter=mysql[slowqueries],mysqladmin -uroot status|cut f5 -d”:”|cut -f1 -d”O”
UserParameter=mysql[qps],mysqladmin -uroot status|cut -f9 d”:”
UserParameter=version[mysql],mysql -V
Exemple de résultats : * mysql[ping]
Check, if MySQL is alive
Result: 0 - not started 1 - alive
* mysql[uptime]
Number of seconds MySQL is running
* mysql[threads]
Number of MySQL threads
* mysql[questions]
Number of processed queries
* mysql[slowqueries]
Number of slow queries
* mysql[qps]
Queries per second
* mysql[version]
Version of MySQL
Example: mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686)
|
