Information Schema THREAD_POOL_GROUPS Table

MariaDB starting with 10.5

The Information Schema THREAD_POOL_GROUPS table was introduced in MariaDB 10.5.0.

The table provides information about thread pool groups, and contains the following columns:

ColumnDescription
GROUP_IDthe thread group this row is showing data for
CONNECTIONSthe number of clients currently connected to this thread group
THREADStotal number of threads in this group (ACTIVE+STANDBY+LISTENER)
ACTIVE_THREADSnumber of threads currently executing a query
STANDBY_THREADSnumber of threads in reserve that do not currently execute anything
QUEUE_LENGTHnumber of client requests waiting for execution
HAS_LISTENERwhether there is an active listener thread right now, always 1 if thread_pool_dedicated_listener is ON
IS_STALLEDwhether there's currently an active worker thread in this group that has exceeded thread_pool_stall_limit time

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.

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.