ps_thread_trx_info
Syntax
sys.ps_thread_trx_info(thread_id)
Contents
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.
Examples
See Also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.