THREAD_POOL_STATS Table

THREAD_POOL_STATS provides statistics about thread group status, for example, the number of threads created by check_stall or the number of tasks polled by a listener thread.

**Table 1** THREAD_POOL_STATS
Field	Description
GROUP_ID	Thread group ID.
THREAD_CREATIONS	Total number of times that threads are successfully created since the thread group is initialized.
THREAD_CREATIONS_DUE_TO_STALL	Number of times that threads are successfully created by check_stall since the thread group is initialized.
WAKES	Total number of thread wake-ups since the thread group is initialized.
WAKES_DUE_TO_STALL	Total number of thread wake-ups by the timer thread since the thread group is initialized.
THROTTLES	Total number of times that threads are successfully created due to timeout detection since the thread group is initialized. The value increases by 1 each time when the timer thread identifies that the interval between the last thread creation time and the current creation exceeds the value of throttling_interval by calling check_stall.
STALLS	Number of stalls detected by the timer thread since the thread group is initialized. The value increases by 1 each time when the timer thread identifies that the thread group is stalled by calling check_stall.
POLLS_BY_LISTENER POLLS_BY_WORKER	Total number of epoll network events since the thread group is initialized. POLLS_BY_WORKER indicates that the poll initiator is a worker thread. POLLS_BY_LISTENER indicates that the initiator is a listener thread.
DEQUEUES_BY_LISTENER DEQUEUES_BY_WORKER	Number of times that tasks are pulled from the queue since the thread group is initialized. DEQUEUES_BY_WORKER indicates that the dequeue initiator is a worker thread. DEQUEUES_BY_LISTENER indicates that the initiator is a listener thread.

Parent topic: New information_schema Tables