1SELECT sys.ps_thread_trx_info(234623462376); 2sys.ps_thread_trx_info(234623462376) 3NULL 4SELECT JSON_VALID(sys.ps_thread_trx_info(sys.ps_thread_id(NULL))); 5JSON_VALID(sys.ps_thread_trx_info(sys.ps_thread_id(NULL))) 61 7CREATE DATABASE trx; 8CREATE TABLE trx.info (id INT PRIMARY KEY, info VARCHAR(20)); 9USE trx; 10START TRANSACTION; 11INSERT INTO info VALUES (1, 'foo'); 12COMMIT; 13START TRANSACTION; 14INSERT INTO info VALUES (2, 'bar'); 15COMMIT; 16SET @json_doc := sys.ps_thread_trx_info(@ps_thread_id); 17SELECT JSON_VALID(@json_doc); 18JSON_VALID(@json_doc) 191 20SELECT JSON_LENGTH(@json_doc); 21JSON_LENGTH(@json_doc) 222 23SELECT JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0]')); 24JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0]')) 25["gtid", "mode", "time", "state", "isolation", "autocommitted", "statements_executed"] 26SELECT JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].time'); 27JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].time') 281 29SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state'); 30JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state') 311 32SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode'); 33JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode') 341 35SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted'); 36JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted') 371 38SELECT JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid'); 39JSON_CONTAINS(@json_doc, '"AUTOMATIC"', '$[0].gtid') 401 41SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation'); 42JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation') 431 44SELECT JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0].statements_executed[0]')); 45JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0].statements_executed[0]')) 46["time", "schema", "sql_text", "rows_sent", "sort_rows", "tmp_tables", "rows_affected", "rows_examined", "tmp_disk_tables", "sort_merge_passes"] 47SELECT JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].statements_executed[0].time'); 48JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].statements_executed[0].time') 491 50SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed[0].sql_text'); 51JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed[0].sql_text') 521 53SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed[0].schema'); 54JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed[0].schema') 551 56SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_examined'); 57JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_examined') 581 59SELECT JSON_CONTAINS(@json_doc, '1', '$[0].statements_executed[0].rows_affected'); 60JSON_CONTAINS(@json_doc, '1', '$[0].statements_executed[0].rows_affected') 611 62SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_sent'); 63JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_sent') 641 65SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_tables'); 66JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_tables') 671 68SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_disk_tables'); 69JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_disk_tables') 701 71SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_rows'); 72JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_rows') 731 74SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_merge_passes'); 75JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_merge_passes') 761 77SELECT JSON_CONTAINS(@json_doc, '"COMMIT"', '$[0].statements_executed[1].sql_text'); 78JSON_CONTAINS(@json_doc, '"COMMIT"', '$[0].statements_executed[1].sql_text') 791 80SET @sys.ps_thread_trx_info.max_length = 100; 81SELECT sys.ps_thread_trx_info(@ps_thread_id); 82sys.ps_thread_trx_info(@ps_thread_id) 83{ "error": "Trx info truncated: Row 1X was cut by GROUP_CONCAT()" } 84SET @sys.ps_thread_trx_info.max_length = NULL; 85SELECT JSON_VALID(sys.ps_thread_trx_info(@ps_thread_id)); 86JSON_VALID(sys.ps_thread_trx_info(@ps_thread_id)) 871 88DROP DATABASE trx; 89