netdata/collectors/python.d.plugin/mysql

mysql

Module monitors one or more mysql servers

Requirements:

• python library MySQLdb (faster) or 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. username which have access to database (defaults to 'root')
2. password (defaults to none)
3. mysql my.cnf configuration file
4. mysql socket (optional)
5. mysql host (ip or hostname)
6. mysql port (defaults to 3306)

Here is an example for 3 servers:

update_every : 10
priority     : 90100
retries      : 5

local:
  'my.cnf'   : '/etc/mysql/my.cnf'
  priority   : 90000

local_2:
  user     : 'root'
  pass : 'blablablabla'
  socket   : '/var/run/mysqld/mysqld.sock'
  update_every : 1

remote:
  user     : 'admin'
  pass : 'bla'
  host     : 'example.org'
  port     : 9000
  retries  : 20

If no configuration is given, module will attempt to connect to mysql server via unix socket at /var/run/mysqld/mysqld.sock without password and with username root

---