Information Schema THREAD_POOL_QUEUES Table
The Information Schema THREAD_POOL_QUEUES
table was introduced in MariaDB 10.5.0.
The table provides information about thread pool queues, and contains the following columns:
Column | Description |
---|---|
POSITION |
|
PRIORITY |
|
CONNECTION_ID |
|
QUEUEING_TIME_MICROSECONDS |
Setting thread_poll_exact_stats 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 thread_pool_dedicated_listener 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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-thread_pool_queues-table/