MYSQLSTAT

NAME
SYNOPSIS
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