Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

THREAD_POOL_QUEUES Table

THREAD_POOL_QUEUES provides connection information in a thread group queue.

Table 1 THREAD_POOL_QUEUES

Field

Description

GROUP_ID

Thread group ID

POSITION

Sequence number assigned to a task in the combined queue of the priority and common queues of all thread groups in a pool

PRIORITY

The value 0 indicates the high-priority queue, and 1 indicates the common queue.

CONNECTION_ID

Unique ID of a connection. The value is the same as the value of id in the output of the show processlist command.

QUEUEING_TIME_MICROSECONDS

Waiting time of a task in a queue, in μs