percona-discussion team mailing list archive

[MARK CALLAGHAN <mdcallag@xxxxxxxxx>]

I have attached a patch that adds more InnoDB disk IO status in SHOW
INNODB STATUS for 5.0.84 percona high perf build 18. The patch is BSD
courtesy of Facebook. Among other things, this will display whether
requests are balanced across the background IO threads. And if you
don't want it in a production release, it is still useful for
verifying performance tests.

Output looks like this:

--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread) 0
requests, 0.00 bytes/r, svc: 0.00 secs, 0.00 msecs/r, 0.00 max msecs
I/O thread 1 state: waiting for i/o request (log thread) 111 requests,
16384.00 bytes/r, svc: 0.00 secs, 0.01 msecs/r, 0.03 max msecs
I/O thread 2 state: waiting for i/o request (read thread) 241
requests, 234202.82 bytes/r, svc: 0.05 secs, 0.19 msecs/r, 0.30 max
msecs
I/O thread 3 state: waiting for i/o request (read thread) 17 requests,
126253.18 bytes/r, svc: 0.00 secs, 0.14 msecs/r, 0.29 max msecs
I/O thread 4 state: waiting for i/o request (read thread) 11 requests,
81920.00 bytes/r, svc: 0.00 secs, 0.10 msecs/r, 0.21 max msecs
I/O thread 5 state: waiting for i/o request (read thread) 5 requests,
88473.60 bytes/r, svc: 0.00 secs, 0.11 msecs/r, 0.24 max msecs
I/O thread 6 state: waiting for i/o request (read thread) 0 requests,
0.00 bytes/r, svc: 0.00 secs, 0.00 msecs/r, 0.00 max msecs
I/O thread 7 state: waiting for i/o request (read thread) 4 requests,
61440.00 bytes/r, svc: 0.00 secs, 0.07 msecs/r, 0.13 max msecs
I/O thread 8 state: waiting for i/o request (read thread) 4 requests,
86016.00 bytes/r, svc: 0.00 secs, 0.09 msecs/r, 0.19 max msecs
I/O thread 9 state: waiting for i/o request (read thread) 5 requests,
137625.60 bytes/r, svc: 0.00 secs, 0.15 msecs/r, 0.19 max msecs
I/O thread 10 state: waiting for i/o request (write thread) 73
requests, 234762.52 bytes/r, svc: 0.03 secs, 0.48 msecs/r, 3.03 max
msecs
I/O thread 11 state: waiting for i/o request (write thread) 51
requests, 396428.55 bytes/r, svc: 0.05 secs, 0.89 msecs/r, 2.96 max
msecs
I/O thread 12 state: waiting for i/o request (write thread) 45
requests, 336782.22 bytes/r, svc: 0.04 secs, 0.80 msecs/r, 3.15 max
msecs
I/O thread 13 state: waiting for i/o request (write thread) 36
requests, 277617.78 bytes/r, svc: 0.03 secs, 0.70 msecs/r, 2.91 max
msecs
I/O thread 14 state: waiting for i/o request (write thread) 31
requests, 244174.45 bytes/r, svc: 0.02 secs, 0.58 msecs/r, 2.38 max
msecs
I/O thread 15 state: waiting for i/o request (write thread) 26
requests, 175182.77 bytes/r, svc: 0.01 secs, 0.54 msecs/r, 2.90 max
msecs
I/O thread 16 state: waiting for i/o request (write thread) 25
requests, 204472.32 bytes/r, svc: 0.01 secs, 0.51 msecs/r, 2.52 max
msecs
I/O thread 17 state: waiting for i/o request (write thread) 26
requests, 349735.38 bytes/r, svc: 0.02 secs, 0.71 msecs/r, 2.29 max
msecs


-- 
Mark Callaghan
mdcallag@xxxxxxxxx

Attachment: percdiff
Description: Binary data