# Information Schema THREAD\_POOL\_QUEUES Table

{% hint style="info" %}
This table is available from MariaDB 10.5.
{% endhint %}

The table provides information about [thread pool](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb) queues, and contains the following columns:

| Column                       | Description                                                                                                                                                                                                           |
| ---------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GROUP\_ID                    | the thread group this row is showing data for                                                                                                                                                                         |
| POSITION                     | position in the groups queue                                                                                                                                                                                          |
| PRIORITY                     | request priority, see [priority scheduling](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-in-mariadb#configuring-priority-scheduling) |
| CONNECTION\_ID               | ID of the client connection that submitted the queued request                                                                                                                                                         |
| QUEUEING\_TIME\_MICROSECONDS | how long the request has already been waiting in the queue in microseconds                                                                                                                                            |

Setting [thread\_poll\_exact\_stats](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables#thread_pool_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](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-pool/thread-pool-system-status-variables#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.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}