Skip to content

mysql

Module mysql monitors one or more MySQL servers.

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

configuration

DSN syntax in details.

jobs:
  - name: local
    dsn: [username[:password]@][protocol[(address)]]/dbname[?param1=value1&...&paramN=valueN]
    # username:password@protocol(address)/dbname?param=value
    # user:password@/dbname
    # Examples:
    # - name: local
    #   dsn: user:pass@unix(/usr/local/var/mysql/mysql.sock)/
    # - name: remote
    #   dsn: user:pass5@localhost/mydb?charset=utf8

If no configuration is given, module will attempt to connect to mysql server via unix socket at: 1. /var/run/mysqld/mysqld.sock without password and with username root; 2. /usr/local/var/mysql/mysql.sock without password and with username root; 3. localhost:3306 without password and with username root.