Bug #71162 MEM does not seem to have a graph to show the innodb i/o threads and activity

• Submitted: 17 Dec 2013 14:23
• Modified: 16 Jan 2014 19:17
• Reporter: Simon Mudd (OCA)
• Status: Verified
• Category: MySQL Enterprise Monitor: Server
• Severity: S4 (Feature request)
• Version: 3.0.2
• OS: Any
• CPU Architecture: Any

[17 Dec 2013 14:23] Simon Mudd

Description:
I see no graph showing the innodb threads and if they are busy or idle. WE can configure the number that are used (this is static which is unfortunate) but it's hard to see if all threads are busy or not and also if the read/write ratio is good.

How to repeat:
see above.

Suggested fix:
Please add a graph showing the number of busy threads read and write (same graph).
This should be easy and the info can be quite interesting.

[18 Dec 2013 6:29] Simon Mudd

Just to be clear, I'm talking about the information shown here in SHOW ENGINE INNODB STATUS\G

--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0

Whether the pending values should also be included I'm not sure. but I see some validity to that as that show additional work which is waiting to happen.

[16 Jan 2014 19:17] MySQL Verification Team

A fully justified feature request.