663486 - mysql graphs: pending reads/writes, history list length, thread states

Status: RESOLVED FIXED

(Cloud Services :: Operations: Metrics/Monitoring, task)

Description

[:Atoll]

would like to have graphs for the following counters from SHOW ENGINE INNODB STATUS:

"File I/O pending" graph:

Given output:

Pending normal aio reads: 0, aio writes: 0,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0

Extract counters: reads, writes, ibuf, log, sync


"Transaction history" graph:

Given output:

History list length 59

Extract counters: history_length


"File I/O threads active" graph:

Given output below, where any state OTHER than "waiting for i/o request" is active:

I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 13 state: waiting for i/o request (read thread)
I/O thread 14 state: doing file i/o (write thread) ev set
I/O thread 25 state: doing file i/o (write thread) ev set

Extract counters (value): ibuf (0), log (0), read (0), write (2)

Comment 1

[Pete Fritchman [:petef]]

also put hard line of # of configured read/write threads

Comment 2

[Pete Fritchman [:petef]]

http://pencil-global.phx.weave.mozilla.com/dash/global/sync_mysql