MYSQLSTAT
NAMESYNOPSIS
DESCRIPTION
CONFIGURATION
DEBUGGING
OIDS
SEE ALSO
AUTHORS
BUG REPORTS
COPYRIGHT
NAME
mysqlstat - net-snmp module for collecting MySQL statistics
SYNOPSIS
In snmpd.conf(5):
dlmod mysqlstat_mib /usr/lib/snmp/mysqlstat.so
DESCRIPTION
Dynamically loadable object module for net-snmp that provides access to mysqld(8) statistics. The module is loaded into snmpd(8) as shown in SYNOPSIS.
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.
Caching
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.
CONFIGURATION
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.
DEBUGGING
The module
defines the following debugging tokens:
mysqlstat_mib
Enables general debugging information.
mysqlstat:sql
Detailed information about SQL transactions.
OIDS
See the file MYSQL-STAT-MIB.txt, for a detailed list of provided OIDs.
SEE ALSO
snmpd.conf(5), snmpd(8), mysqlstat-setup(1), mysqld(8).
AUTHORS
Sergey Poznyakoff
BUG REPORTS
Report bugs to <gray@gnu.org>.
COPYRIGHT
Copyright
© 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 man.gnu.org.ua.
Powered by mansrv 1.1