Information Schema THREAD_POOL_QUEUES Table - Source

You are viewing an old version of this article. View the current version here

Revision: 96443
User: Ian Gilfillan
Date: 2020-06-07 22:46

<<product mariadb from=10.5>>
The [[information_schema|Information Schema]] ##THREAD_POOL_QUEUES## table was introduced in MariaDB 10.5.0.
<</product>>

Setting [[thread-pool-system-status-variables/#thread_pool_exact_stats|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-system-status-variables/#thread_pool_dedicated_listener|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.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Information Schema THREAD_POOL_QUEUES Table - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB