The Information Schema THREAD_POOL_QUEUES table shows the status of the queues within the thread pool, detailing pending connections.
The table provides information about thread pool queues, and contains the following columns:
GROUP_ID
the thread group this row is showing data for
Setting will provides better queueing time statistics by using a high precision timestamp, at a small performance cost, for the time when the connection was added to the queue. This timestamp helps calculate the queuing time shown in the table.
Setting will give each group its own dedicated listener, and the listener thread will not pick up work items. As a result, the queueing time in the table will be more exact, since IO requests are immediately dequeued from poll, without delay.
This page is licensed: CC BY-SA / Gnu FDL
POSITION
position in the groups queue
PRIORITY
request priority, see priority scheduling
CONNECTION_ID
ID of the client connection that submitted the queued request
QUEUEING_TIME_MICROSECONDS
how long the request has already been waiting in the queue in microseconds