Closed Bug 663486 Opened 14 years ago Closed 14 years ago

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

Categories

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

x86
macOS
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: Atoll, Unassigned)

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
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.