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.