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