summaryrefslogtreecommitdiffabout
path: root/src/mysqlstat.8
blob: f79e9cfef60daa71f93a57fee38a0680fd1fa867 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
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.