mysql

README

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

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

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.

---

Documentation

Index

• type Charts
• type Dims
• type MySQL
  • func New() *MySQL
  • func (m *MySQL) Charts() *Charts
  • func (m *MySQL) Check() bool
  • func (m *MySQL) Cleanup()
  • func (m *MySQL) Collect() map[string]int64
  • func (m *MySQL) Init() bool

Types

type Charts

type Charts = module.Charts

Charts is an alias for module.Charts

type Dims

type Dims = module.Dims

Dims is an alias for module.Dims

type MySQL

type MySQL struct {
	module.Base

	// i.e user:password@/dbname
	DSN string `yaml:"dsn"`
	// contains filtered or unexported fields
}

MySQL is the mysql database module.

func New

func New() *MySQL

New creates and returns a new empty MySQL module.

func (*MySQL) Charts

func (m *MySQL) Charts() *Charts

Charts creates Charts.

func (*MySQL) Check

func (m *MySQL) Check() bool

Check makes check.

func (*MySQL) Cleanup

func (m *MySQL) Cleanup()

Cleanup performs cleanup.

func (*MySQL) Collect

func (m *MySQL) Collect() map[string]int64

Collect collects health checks and metrics for MySQL.

func (*MySQL) Init

func (m *MySQL) Init() bool

Init makes initialization of the MySQL mod.