Information Schema WSREP_THD_STATE

The Information Schema WSREP_THD_STATE table displays the internal state of Galera threads, helping to monitor replication progress and locking.

This table is used in MariaDB Galera Cluster.

This table is available as of MariaDB Enterprise Server 11.8.

This table contains execution state information for Galera threads, and has these columns:

• ID - Thread ID

• OS_THREAD_ID - Os thread ID

• CLIENT_MODE - Client mode (local, high priority, toi...)

• CLIENT_STATE - Wsrep query state (idle, exec, result...)

• TRANSACTION_STATE - Wsrep transaction state or "none" if no active transaction

• SEQNO - Commit order seqno if assigned, otherwise -1

• DEPENDS_ON - Depends on seqno if assigned, otherwise -1 The table must have low overhead (populated only when queried) and must be enabled at all times (not plugin or plugin must be loaded by default).

• GTID - transaction GTID assigned during commit phase

Example output:

SELECT * FROM information_schema.wsrep_thd_info;
ID	OS_THREAD_ID	MODE	STATE	TRANSACTION_ID	TRANSACTION_STATE	SEQNO	DEPENDS_ON	GTID
14	128875466565312	local	exec	64	executing	NULL	NULL	NULL
13	128875466872512	local	exec	61	committing	9	3	0-1-7
12	128875467179712	local	idle	NULL	aborted	NULL	NULL	NULL
2	128875634570944	high priority	exec	NULL	executing	NULL	NULL	NULL
1	128875634878144	local	none	NULL	executing	NULL	NULL	NULL

There is also an INFORMATION_SCHEMA.WSREP_THD_STATE_HISTORY table that contains the history of execution state information for Galera threads.