| 1 |
SELECT sys.ps_thread_trx_info(234623462376); |
| 2 |
sys.ps_thread_trx_info(234623462376) |
| 3 |
NULL |
| 4 |
SELECT JSON_VALID(sys.ps_thread_trx_info(ps_current_thread_id())); |
| 5 |
JSON_VALID(sys.ps_thread_trx_info(ps_current_thread_id())) |
| 6 |
1 |
| 7 |
CREATE DATABASE trx; |
| 8 |
CREATE TABLE trx.info (id INT PRIMARY KEY, info VARCHAR(20)); |
| 9 |
# Warm-up data-dictionary cache. |
| 10 |
USE trx; |
| 11 |
START TRANSACTION; |
| 12 |
INSERT INTO info VALUES (1, 'foo'); |
| 13 |
COMMIT; |
| 14 |
START TRANSACTION; |
| 15 |
INSERT INTO info VALUES (2, 'bar'); |
| 16 |
COMMIT; |
| 17 |
SET @json_doc := sys.ps_thread_trx_info(@ps_thread_id); |
| 18 |
SELECT JSON_VALID(@json_doc); |
| 19 |
JSON_VALID(@json_doc) |
| 20 |
1 |
| 21 |
SELECT JSON_LENGTH(@json_doc); |
| 22 |
JSON_LENGTH(@json_doc) |
| 23 |
2 |
| 24 |
SELECT JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0]')); |
| 25 |
JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0]')) |
| 26 |
["gtid", "mode", "time", "state", "isolation", "autocommitted", "statements_executed"] |
| 27 |
SELECT JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].time'); |
| 28 |
JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].time') |
| 29 |
1 |
| 30 |
SELECT JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state'); |
| 31 |
JSON_CONTAINS(@json_doc, '"COMMITTED"', '$[0].state') |
| 32 |
1 |
| 33 |
SELECT JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode'); |
| 34 |
JSON_CONTAINS(@json_doc, '"READ WRITE"', '$[0].mode') |
| 35 |
1 |
| 36 |
SELECT JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted'); |
| 37 |
JSON_CONTAINS(@json_doc, '"NO"', '$[0].autocommitted') |
| 38 |
1 |
| 39 |
SELECT JSON_EXTRACT(@json_doc, '$[0].gtid'); |
| 40 |
JSON_EXTRACT(@json_doc, '$[0].gtid') |
| 41 |
"GTID" |
| 42 |
SELECT JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation'); |
| 43 |
JSON_CONTAINS(@json_doc, '"REPEATABLE READ"', '$[0].isolation') |
| 44 |
1 |
| 45 |
SELECT JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0].statements_executed[0]')); |
| 46 |
JSON_KEYS(JSON_EXTRACT(@json_doc, '$[0].statements_executed[0]')) |
| 47 |
["time", "schema", "sql_text", "rows_sent", "sort_rows", "tmp_tables", "rows_affected", "rows_examined", "tmp_disk_tables", "sort_merge_passes"] |
| 48 |
SELECT JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].statements_executed[0].time'); |
| 49 |
JSON_CONTAINS_PATH(@json_doc, 'one', '$[0].statements_executed[0].time') |
| 50 |
1 |
| 51 |
SELECT JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed[0].sql_text'); |
| 52 |
JSON_CONTAINS(@json_doc, '"INSERT INTO info VALUES (1, \'foo\')"', '$[0].statements_executed[0].sql_text') |
| 53 |
1 |
| 54 |
SELECT JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed[0].schema'); |
| 55 |
JSON_CONTAINS(@json_doc, '"trx"', '$[0].statements_executed[0].schema') |
| 56 |
1 |
| 57 |
SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_examined'); |
| 58 |
JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_examined') |
| 59 |
1 |
| 60 |
SELECT JSON_CONTAINS(@json_doc, '1', '$[0].statements_executed[0].rows_affected'); |
| 61 |
JSON_CONTAINS(@json_doc, '1', '$[0].statements_executed[0].rows_affected') |
| 62 |
1 |
| 63 |
SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_sent'); |
| 64 |
JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].rows_sent') |
| 65 |
1 |
| 66 |
SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_tables'); |
| 67 |
JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_tables') |
| 68 |
1 |
| 69 |
SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_disk_tables'); |
| 70 |
JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].tmp_disk_tables') |
| 71 |
1 |
| 72 |
SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_rows'); |
| 73 |
JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_rows') |
| 74 |
1 |
| 75 |
SELECT JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_merge_passes'); |
| 76 |
JSON_CONTAINS(@json_doc, '0', '$[0].statements_executed[0].sort_merge_passes') |
| 77 |
1 |
| 78 |
SELECT JSON_CONTAINS(@json_doc, '"COMMIT"', '$[0].statements_executed[1].sql_text'); |
| 79 |
JSON_CONTAINS(@json_doc, '"COMMIT"', '$[0].statements_executed[1].sql_text') |
| 80 |
1 |
| 81 |
SET @sys.ps_thread_trx_info.max_length = 100; |
| 82 |
SELECT sys.ps_thread_trx_info(@ps_thread_id); |
| 83 |
sys.ps_thread_trx_info(@ps_thread_id) |
| 84 |
{ "error": "Trx info truncated: Row 4 was cut by GROUP_CONCAT()" } |
| 85 |
SET @sys.ps_thread_trx_info.max_length = NULL; |
| 86 |
SELECT JSON_VALID(sys.ps_thread_trx_info(@ps_thread_id)); |
| 87 |
JSON_VALID(sys.ps_thread_trx_info(@ps_thread_id)) |
| 88 |
1 |
| 89 |
DROP DATABASE trx; |