ps_thread_trx_info

The ps_thread_trx_info function returns a JSON object detailing the current transaction and executed statements for a specific thread.

Sys Schema is available from MariaDB 10.6.

Syntax

sys.ps_thread_trx_info(thread_id)

Description

ps_thread_trx_info is a stored function available with the Sys Schema.

It returns a JSON object with information about the thread specified by the given thread_id. This information includes:

• the current transaction;

• executed statements (derived from the Performance Schema events_transactions_current Table and the Performance Schema events_statements_history Table (full data will only returned if the consumers for those tables are enabled).

The maximum length of the returned JSON object is determined by the value of the ps_thread_trx_info.max_length sys_config option (by default 65535). If the returned value exceeds this length, a JSON object error is returned.

See Also

• Sys Schema sys_config Table

_{This page is licensed: CC BY-SA / Gnu FDL}