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

RESOLVED FIXED

Status

RESOLVED FIXED
8 years ago
7 years ago

People

(Reporter: atoll, Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

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)
also put hard line of # of configured read/write threads
http://pencil-global.phx.weave.mozilla.com/dash/global/sync_mysql
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.