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 kilobits/s

   • in
   • out

2. Queries in queries/sec

   • queries
   • questions
   • slow queries

3. Queries By Type in queries/s

   • select
   • delete
   • update
   • insert
   • cache hits
   • replace

4. Handlerse in handlers/s

   • commit
   • delete
   • prepare
   • read first
   • read key
   • read next
   • read prev
   • read rnd
   • read rnd next
   • rollback
   • savepoint
   • savepoint rollback
   • update
   • write

5. Table Locks in locks/s

   • immediate
   • waited

6. Table Select Join Issuess in joins/s

   • full join
   • full range join
   • range
   • range check
   • scan

7. Table Sort Issuess in joins/s

   • merge passes
   • range
   • scan

8. Tmp Operations in created/s

   • disk tables
   • files
   • tables

9. Connections in connections/s

   • all
   • aborted

10. Connections Active in connections/s

    • active
    • limit
    • max active

11. Binlog Cache in threads

    • disk
    • all

12. Threads in transactions/s

    • connected
    • cached
    • running

13. Threads Creation Rate in threads/s

    • created

14. Threads Cache Misses in misses

    • misses

15. InnoDB I/O Bandwidth in KiB/s

    • read
    • write

16. InnoDB I/O Operations in operations/s

    • reads
    • writes
    • fsyncs

17. InnoDB Pending I/O Operations in operations/s

    • reads
    • writes
    • fsyncs

18. InnoDB Log Operations in operations/s

    • waits
    • write requests
    • writes

19. InnoDB OS Log Pending Operations in operations

    • fsyncs
    • writes

20. InnoDB OS Log Operations in operations/s

    • fsyncs

21. InnoDB OS Log Bandwidth in KiB/s

    • write

22. InnoDB Current Row Locks in operations

    • current waits

23. InnoDB Row Operations in operations/s

    • inserted
    • read
    • updated
    • deleted

24. InnoDB Buffer Pool Pagess in pages

    • data
    • dirty
    • free
    • misc
    • total

25. InnoDB Buffer Pool Flush Pages Requests in requests/s

    • flush pages

26. InnoDB Buffer Pool Bytes in MiB

    • data
    • dirty

27. InnoDB Buffer Pool Operations in operations/s

    • disk reads
    • wait free

28. QCache Operations in queries/s

    • hits
    • lowmem prunes
    • inserts
    • no caches

29. QCache Queries in Cache in queries

    • queries

30. QCache Free Memory in MiB

    • free

31. QCache Memory Blocks in blocks

    • free
    • total

32. MyISAM Key Cache Blocks in blocks

    • unused
    • used
    • not flushed

33. MyISAM Key Cache Requests in requests/s

    • reads
    • writes

34. MyISAM Key Cache Requests in requests/s

    • reads
    • writes

35. MyISAM Key Cache Disk Operations in operations/s

    • reads
    • writes

36. Open Files in files

    • files

37. Opened Files Rate in files/s

    • files

38. Binlog Statement Cache in statements/s

    • disk
    • all

39. Connection Errors in errors/s

    • accept
    • internal
    • max
    • peer addr
    • select
    • tcpwrap

40. Slave Behind Seconds in seconds

    • time

41. I/O / SQL Thread Running State in bool

    • sql
    • io

42. Replicated Writesets in writesets/s

    • rx
    • tx

43. Replicated Bytes in KiB/s

    • rx
    • tx

44. Galera Queue in writesets

    • rx
    • tx

45. Replication Conflicts in transactions

    • bf aborts
    • cert fails

46. Flow Control in ms

    • paused

47. Users CPU time in percentage

    • users

Per user statistics:

1. Rows Operations in operations/s

   • read
   • send
   • updated
   • inserted
   • deleted

2. Commands in commands/s

   • select
   • update
   • other

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)

7. ssl connection parameters

   • key: the path name of the client private key file.
   • cert: the path name of the client public key certificate file.
   • ca: the path name of the Certificate Authority (CA) certificate file. This option, if used, must specify the same certificate used by the server.
   • capath: the path name of the directory that contains trusted SSL CA certificate files.
   • cipher: the list of permitted ciphers for SSL encryption.

Here is an example for 3 servers:

update_every : 10
priority     : 90100

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

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

userstats graph works only if you enable such plugin in MariaDB server and set proper mysql priviliges (SUPER or PROCESS). For more detail please check MariaDB User Statistics page

---

[](<>)