THREAD_POOL_WAITS

Topics on this page:

Overview

In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS:: Provides information about thread pool waits.

CREATE TEMPORARY TABLE `THREAD_POOL_WAITS` (
  `REASON` varchar(16) NOT NULL,
  `COUNT` bigint(19) NOT NULL
)

Variable	Description
REASON	Name of the reason for waiting, e.g., ROW_LOCK, DISKIO, NET
COUNT	How often that reason caused a wait so far

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1. Schema changed in MariaDB Enterprise Server 10.6.7-3: ... CREATE TEMPORARY TABLE `THREAD_POOL_WAITS` ( `REASON` varchar(16) NOT NULL DEFAULT '', `COUNT` bigint(19) NOT NULL DEFAULT 0 )
10.6 Community	Present starting in MariaDB Community Server 10.6.0. Schema changed in MariaDB Community Server 10.6.6: ... CREATE TEMPORARY TABLE `THREAD_POOL_WAITS` ( `REASON` varchar(16) NOT NULL DEFAULT '', `COUNT` bigint(19) NOT NULL DEFAULT 0 )
10.5 Enterprise	Added in MariaDB Enterprise Server 10.5.3-1. Schema changed in MariaDB Enterprise Server 10.5.15-10: ... CREATE TEMPORARY TABLE `THREAD_POOL_WAITS` ( `REASON` varchar(16) NOT NULL DEFAULT '', `COUNT` bigint(19) NOT NULL DEFAULT 0 )
10.5 Community	Added in MariaDB Community Server 10.5.0. Schema changed in MariaDB Community Server 10.5.14: ... CREATE TEMPORARY TABLE `THREAD_POOL_WAITS` ( `REASON` varchar(16) NOT NULL DEFAULT '', `COUNT` bigint(19) NOT NULL DEFAULT 0 )
10.4 Enterprise	Not present.
10.4 Community	Not present.
10.3 Enterprise	Not present.
10.3 Community	Not present.
10.2 Enterprise	Not present.
10.2 Community	Not present.

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1. Schema changed in MariaDB Enterprise Server 10.6.7-3: ... CREATE TEMPORARY TABLE `THREAD_POOL_WAITS` ( `REASON` varchar(16) NOT NULL DEFAULT '', `COUNT` bigint(19) NOT NULL DEFAULT 0 )
10.5 Enterprise	Added in MariaDB Enterprise Server 10.5.3-1. Schema changed in MariaDB Enterprise Server 10.5.15-10: ... CREATE TEMPORARY TABLE `THREAD_POOL_WAITS` ( `REASON` varchar(16) NOT NULL DEFAULT '', `COUNT` bigint(19) NOT NULL DEFAULT 0 )
10.4 Enterprise	Not present.