# Information Schema WSREP\_THD\_STATE

{% hint style="info" %}
This table is used in [MariaDB Galera Cluster](https://mariadb.com/docs/galera-cluster/).
{% endhint %}

{% hint style="info" %}
This table is available as of MariaDB Enterprise Server 11.8.
{% endhint %}

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:

```sql
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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_thd_state.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.