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
|
# Disclaimer
Currently every plugin must be written in python3.
All third party libraries should be installed system-wide or in `python_modules` directory.
Also plugins support changing their data collection frequency by setting `update_every` variable in their configuration file.
The following python.d plugins are supported:
# mysql
The plugin will monitor one or more mysql servers
**Requirements:**
* python module [MySQLdb](https://github.com/PyMySQL/mysqlclient-python) (faster) or [PyMySQL](https://github.com/PyMySQL/PyMySQL) (slower)
It will produce following charts (if data is available):
1. **Bandwidth** in kbps
* in
* out
2. **Queries** in queries/sec
* queries
* questions
* slow queries
3. **Operations** in operations/sec
* opened tables
* flush
* commit
* delete
* prepare
* read first
* read key
* read next
* read prev
* read random
* read random next
* rollback
* save point
* update
* write
4. **Table Locks** in locks/sec
* immediate
* waited
5. **Select Issues** in issues/sec
* full join
* full range join
* range
* range check
* scan
6. **Sort Issues** in issues/sec
* merge passes
* range
* scan
### configuration
You can provide, per server, the following:
1. a name, anything you like, but keep it short
2. username which have access to database (deafults to 'root')
3. password (defaults to none)
4. mysql my.cnf configuration file
5. mysql socket (optional)
6. mysql host (ip or hostname)
7. mysql port (defaults to 3306)
Here is an example for 3 servers updating data every 10 seconds
```js
update_every = 10
config=[
{
'name' : 'local',
'my.cnf' : '/etc/mysql/my.cnf'
},{
'name' : 'local_2',
'user' : 'root',
'password' : 'blablablabla',
'socket' : '/var/run/mysqld/mysqld.sock'
},{
'name' : 'remote',
'user' : 'admin',
'password' : 'bla',
'host' : 'example.org',
'port' : '9000'
}]
```
If no configuration is given, the plugin will attempt to connect to mysql server via unix socket at `/var/run/mysqld/mysqld.sock` without password and username `root`
---
|
