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)
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)
Comment 1•14 years ago
|
||
also put hard line of # of configured read/write threads
Comment 2•14 years ago
|
||
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.
Description
•