Parameters
| Name | Type | Mode |
|---|---|---|
| in_thread_id | bigint unsigned | IN |
Returns a JSON object with info on the given threads current transaction, and the statements it has already executed, derived from the performance_schema.events_transactions_current and performance_schema.events_statements_history tables (so the consumers for these also have to be enabled within Performance Schema to get full data in the object).
When the output exceeds the default truncation length (65535), a JSON error object is returned, such as:
{ “error”: “Trx info truncated: Row 6 was cut by GROUP_CONCAT()” }
Similar error objects are returned for other warnings/and exceptions raised when calling the function.
The max length of the output of this function can be controlled with the ps_thread_trx_info.max_length variable set via sys_config, or the @sys.ps_thread_trx_info.max_length user variable, as appropriate.
in_thread_id (BIGINT UNSIGNED): The id of the thread to return the transaction info for.
SELECT sys.ps_thread_trx_info(48)\G *************************** 1. row *************************** sys.ps_thread_trx_info(48): [ { “time”: “790.70 us”, “state”: “COMMITTED”, “mode”: “READ WRITE”, “autocommitted”: “NO”, “gtid”: “AUTOMATIC”, “isolation”: “REPEATABLE READ”, “statements_executed”: [ { “sql_text”: “INSERT INTO info VALUES (1, ‘foo’)”, “time”: “471.02 us”, “schema”: “trx”, “rows_examined”: 0, “rows_affected”: 1, “rows_sent”: 0, “tmp_tables”: 0, “tmp_disk_tables”: 0, “sort_rows”: 0, “sort_merge_passes”: 0 }, { “sql_text”: “COMMIT”, “time”: “254.42 us”, “schema”: “trx”, “rows_examined”: 0, “rows_affected”: 0, “rows_sent”: 0, “tmp_tables”: 0, “tmp_disk_tables”: 0, “sort_rows”: 0, “sort_merge_passes”: 0 } ] }, { “time”: “426.20 us”, “state”: “COMMITTED”, “mode”: “READ WRITE”, “autocommitted”: “NO”, “gtid”: “AUTOMATIC”, “isolation”: “REPEATABLE READ”, “statements_executed”: [ { “sql_text”: “INSERT INTO info VALUES (2, ‘bar’)”, “time”: “107.33 us”, “schema”: “trx”, “rows_examined”: 0, “rows_affected”: 1, “rows_sent”: 0, “tmp_tables”: 0, “tmp_disk_tables”: 0, “sort_rows”: 0, “sort_merge_passes”: 0 }, { “sql_text”: “COMMIT”, “time”: “213.23 us”, “schema”: “trx”, “rows_examined”: 0, “rows_affected”: 0, “rows_sent”: 0, “tmp_tables”: 0, “tmp_disk_tables”: 0, “sort_rows”: 0, “sort_merge_passes”: 0 } ] } ] 1 row in set (0.03 sec)
| Name | Type | Mode |
|---|---|---|
| in_thread_id | bigint unsigned | IN |