arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

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.

circle-info

Sys Schema is available from MariaDB 10.6.

hashtag
Syntax

hashtag
Description

ps_thread_trx_info is a available with the .

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 and the (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 (by default 65535). If the returned value exceeds this length, a JSON object error is returned.

hashtag
See Also

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

sys.ps_thread_trx_info(thread_id)
stored function
Sys Schema
Performance Schema events_transactions_current Table
Performance Schema events_statements_history Table
ps_thread_trx_info.max_length sys_config option
Sys Schema sys_config Table
spinner