Rate This Document
Findability
Accuracy
Completeness
Readability

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

Queuing time of a task, in μs.