Skip to content

Latest commit

 

History

History
 
 

mysql

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Makefile.inc
Makefile.inc
 
 
README.md
README.md
 
 
mysql.chart.py
mysql.chart.py
 
 
mysql.conf
mysql.conf
 
 

README.md

mysql

Module monitors one or more mysql servers

Requirements:

It will produce following charts (if data is available):

  1. Bandwidth in kilobits/s
  • in
  • out
  1. Queries in queries/sec
  • queries
  • questions
  • slow queries
  1. Queries By Type in queries/s
  • select
  • delete
  • update
  • insert
  • cache hits
  • replace
  1. 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
  1. Table Locks in locks/s
  • immediate
  • waited
  1. Table Select Join Issuess in joins/s
  • full join
  • full range join
  • range
  • range check
  • scan
  1. Table Sort Issuess in joins/s
  • merge passes
  • range
  • scan
  1. Tmp Operations in created/s
  • disk tables
  • files
  • tables
  1. Connections in connections/s
  • all
  • aborted
  1. Connections Active in connections/s
  • active
  • limit
  • max active
  1. Binlog Cache in threads
  • disk
  • all
  1. Threads in transactions/s
  • connected
  • cached
  • running
  1. Threads Creation Rate in threads/s
  • created
  1. Threads Cache Misses in misses
  • misses
  1. InnoDB I/O Bandwidth in KiB/s
  • read
  • write
  1. InnoDB I/O Operations in operations/s
  • reads
  • writes
  • fsyncs
  1. InnoDB Pending I/O Operations in operations/s
  • reads
  • writes
  • fsyncs
  1. InnoDB Log Operations in operations/s
  • waits
  • write requests
  • writes
  1. InnoDB OS Log Pending Operations in operations
  • fsyncs
  • writes
  1. InnoDB OS Log Operations in operations/s
  • fsyncs
  1. InnoDB OS Log Bandwidth in KiB/s
  • write
  1. InnoDB Current Row Locks in operations
  • current waits
  1. InnoDB Row Operations in operations/s
  • inserted
  • read
  • updated
  • deleted
  1. InnoDB Buffer Pool Pagess in pages
  • data
  • dirty
  • free
  • misc
  • total
  1. InnoDB Buffer Pool Flush Pages Requests in requests/s
  • flush pages
  1. InnoDB Buffer Pool Bytes in MiB
  • data
  • dirty
  1. InnoDB Buffer Pool Operations in operations/s
  • disk reads
  • wait free
  1. QCache Operations in queries/s
  • hits
  • lowmem prunes
  • inserts
  • no caches
  1. QCache Queries in Cache in queries
  • queries
  1. QCache Free Memory in MiB
  • free
  1. QCache Memory Blocks in blocks
  • free
  • total
  1. MyISAM Key Cache Blocks in blocks
  • unused
  • used
  • not flushed
  1. MyISAM Key Cache Requests in requests/s
  • reads
  • writes
  1. MyISAM Key Cache Requests in requests/s
  • reads
  • writes
  1. MyISAM Key Cache Disk Operations in operations/s
  • reads
  • writes
  1. Open Files in files
  • files
  1. Opened Files Rate in files/s
  • files
  1. Binlog Statement Cache in statements/s
  • disk
  • all
  1. Connection Errors in errors/s
  • accept
  • internal
  • max
  • peer addr
  • select
  • tcpwrap
  1. Slave Behind Seconds in seconds
  • time
  1. I/O / SQL Thread Running State in bool
  • sql
  • io
  1. Replicated Writesets in writesets/s
  • rx
  • tx
  1. Replicated Bytes in KiB/s
  • rx
  • tx
  1. Galera Queue in writesets
  • rx
  • tx
  1. Replication Conflicts in transactions
  • bf aborts
  • cert fails
  1. Flow Control in ms
  • paused

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

analytics