mysqlstat − net-snmp module for collecting MySQL statistics
dlmod mysqlstat_mib /usr/lib/snmp/mysqlstat.so
The module provides access to the MySQL process list (as returned by SHOW PROCESSLIST command) and to replication status. The module connects to the MySQL server using credentials obtained from file /etc/snmp/mysqlstat.cnf, section [mysqlstat] (the file has the same format as the traditional /etc/my.cnf file). The MySQL user must be granted the PROCESS, and REPLICATION CLIENT privileges.
To configure the module, it is recommended to use the mysqlstat−setup(1) utility.
In order to minimize its impact on MySQL server, the mysqlstat module caches the data obtained from the server. Default caching interval is 10 seconds for tabular information. Additionally, results of each SHOW PROCESSLIST are cached for 10 seconds. This means that updates of processListTable entries may delay for up to 20 seconds.
As of version 1.0, these delays are not configurable.
MySQL credentials are read from file /etc/snmp/mysqlstat.cnf. The file has the standard MySQL ini file format. The section [mysqlstat] is read.
An example of mysqlstat.cnf follows:
[mysqlstat] user=snmp password=guessme
The file must be readable by the user snmpd runs as.
defines the following debugging tokens:
Enables general debugging information.
Detailed information about SQL transactions.
See the file MYSQL-STAT-MIB.txt, for a detailed list of provided OIDs.
Report bugs to <email@example.com>.
© 2016 Sergey Poznyakoff
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
Manpage server at Ulysses.gnu.org.ua.
Powered by mansrv 1.0