aboutsummaryrefslogtreecommitdiff
path: root/src/mysqlstat.8
diff options
context:
space:
mode:
Diffstat (limited to 'src/mysqlstat.8')
-rw-r--r--src/mysqlstat.8105
1 files changed, 105 insertions, 0 deletions
diff --git a/src/mysqlstat.8 b/src/mysqlstat.8
new file mode 100644
index 0000000..f79e9cf
--- /dev/null
+++ b/src/mysqlstat.8
@@ -0,0 +1,105 @@
+.\" This file is part of Mysqlstat -*- nroff -*-
+.\" Copyright (C) 2016 Sergey Poznyakoff
+.\"
+.\" Mysqlstat is free software; you can redistribute it and/or modify
+.\" it under the terms of the GNU General Public License as published by
+.\" the Free Software Foundation; either version 3, or (at your option)
+.\" any later version.
+.\"
+.\" Mysqlstat is distributed in the hope that it will be useful,
+.\" but WITHOUT ANY WARRANTY; without even the implied warranty of
+.\" MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+.\" GNU General Public License for more details.
+.\"
+.\" You should have received a copy of the GNU General Public License
+.\" along with Mysqlstat. If not, see <http://www.gnu.org/licenses/>.
+.TH MYSQLSTAT 8 "June 8, 2016" "mysqlstat"
+.SH NAME
+mysqlstat \- net-snmp module for collecting MySQL statistics
+.SH SYNOPSIS
+In \fBsnmpd.conf\fR(5):
+.PP
+.B dlmod mysqlstat_mib /usr/lib/snmp/mysqlstat.so
+.SH DESCRIPTION
+Dynamically loadable object module for
+.B net-snmp
+that provides access to
+.BR mysqld (8)
+statistics. The module is loaded into
+.BR snmpd (8)
+as shown in
+.BR SYNOPSIS .
+.PP
+The module provides access to the MySQL process list (as returned by
+.B SHOW PROCESSLIST
+command) and to replication status. The module connects to the MySQL
+server using credentials obtained from file
+.BR /etc/snmp/mysqlstat.cnf ,
+section
+.B [mysqlstat]
+(the file has the same format as the traditional
+.B /etc/my.cnf
+file). The MySQL user must be granted the
+.BR PROCESS ,
+and
+.B REPLICATION CLIENT
+privileges.
+.PP
+To configure the module, it is recommended to use the
+.BR mysqlstat\-setup (1)
+utility.
+.SH CONFIGURATION
+MySQL credentials are read from file
+.BR /etc/snmp/mysqlstat.cnf .
+The file has the standard MySQL ini file format. The section
+.B [mysqlstat]
+is read.
+.PP
+An example of \fBmysqlstat.cnf\fR follows:
+.PP
+.EX
+[mysqlstat]
+user=snmp
+password=guessme
+.EE
+.PP
+The file must be readable by the user
+.B snmpd
+runs as.
+.SH DEBUGGING
+The module defines the following debugging tokens:
+.TP
+.B mysqlstat_mib
+Enables general debugging information.
+.TP
+.B mysqlstat:sql
+Detailed information about SQL transactions.
+.SH OIDS
+See the file
+.BR MYSQL-STAT-MIB.txt ,
+for a detailed list of provided OIDs.
+.SH SEE ALSO
+.BR snmpd.conf (5),
+.BR snmpd (8),
+.BR mysqlstat\-setup (1),
+.BR mysqld (8).
+.SH AUTHORS
+Sergey Poznyakoff
+.SH "BUG REPORTS"
+Report bugs to <gray@gnu.org>.
+.SH COPYRIGHT
+Copyright \(co 2016 Sergey Poznyakoff
+.br
+.na
+License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
+.br
+.ad
+This is free software: you are free to change and redistribute it.
+There is NO WARRANTY, to the extent permitted by law.
+.\" Local variables:
+.\" eval: (add-hook 'write-file-hooks 'time-stamp)
+.\" time-stamp-start: ".TH [A-Z_][A-Z0-9_.-]* [0-9] \""
+.\" time-stamp-format: "%:B %:d, %:y"
+.\" time-stamp-end: "\""
+.\" time-stamp-line-limit: 20
+.\" end:

Return to:

Send suggestions and report system problems to the System administrator.