SHOW INNODB STATUS should print the thread ID for all background threads

[Baron Schwartz]

It would be good to print the thread ID for all the threads, like these:

--------
FILE I/O
--------
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 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (read thread)
I/O thread 7 state: waiting for i/o request (read thread)
I/O thread 8 state: waiting for i/o request (read thread)
I/O thread 9 state: waiting for i/o request (read thread)
I/O thread 10 state: waiting for i/o request (write thread)
I/O thread 11 state: waiting for i/o request (write thread)
I/O thread 12 state: waiting for i/o request (write thread)
I/O thread 13 state: waiting for i/o request (write thread)
I/O thread 14 state: waiting for i/o request (write thread)
I/O thread 15 state: waiting for i/o request (write thread)
I/O thread 16 state: waiting for i/o request (write thread)
I/O thread 17 state: waiting for i/o request (write thread)

Sometimes I can see a semaphore wait, and I can see the "last time locked by thread ID X" text, but there is no transction with that thread ID X. It would be good to be able to find out that this is in fact one of the IO threads, or other background threads. (What is the thread ID of the purge thread?)

[Stewart Smith (stewart)]

Moving to Percona Server. Is this still valid?

[Baron Schwartz (baron-xaprb)]

I think we should implement this request. Right now a lot of mutex
contention issues can't be resolved without also having a stack trace
so you can see what thread ID XXXXXXXXXXX is.

[Laurynas Biveinis (laurynas-biveinis)]

Duplicate of bug 592365 (despite that its title only mentions purge)