The Information Schema THREADPOOL_GROUPS
table was introduced in MariaDB 10.5.0.
It contains the following columns:
Column | Description |
---|---|
GROUP_ID |
|
CONNECTIONS |
|
THREADS |
|
ACTIVE_THREADS |
|
STANDBY_THREADS |
|
QUEUE_LENGTH |
|
HAS_LISTENER |
|
IS_STALLED |
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 actual queue size in the table will be more exact, since IO requests are immediately dequeued from poll, without delay.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-threadpool_groups-table/