percona-discussion team mailing list archive

[Vadim Tkachenko <vadim@xxxxxxxxxxx>]

Thanks Mark,

I am going to include it into releases.

Alexandr, can you prepare patch for our LP tree ?


On Thu, Aug 13, 2009 at 12:24 AM, MARK CALLAGHAN<mdcallag@xxxxxxxxx> wrote:
> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~percona-discussion
> Post to     : percona-discussion@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~percona-discussion
> More help   : https://help.launchpad.net/ListHelp
>
>