SELECT * FROM `events_transactions_history`
|
THREAD_ID | EVENT_ID | END_EVENT_ID | EVENT_NAME | STATE | TRX_ID | GTID | XID_FORMAT_ID | XID_GTRID | XID_BQUAL | XA_STATE | SOURCE | TIMER_START | TIMER_END | TIMER_WAIT | ACCESS_MODE | ISOLATION_LEVEL | AUTOCOMMIT | NUMBER_OF_SAVEPOINTS | NUMBER_OF_ROLLBACK_TO_SAVEPOINT | NUMBER_OF_RELEASE_SAVEPOINT | OBJECT_INSTANCE_BEGIN | NESTING_EVENT_ID | NESTING_EVENT_TYPE | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 11 | 11 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490548364000 | 1490555194000 | 6830000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490626006000 | 1490633758000 | 7752000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1490999153000 | 1491005885000 | 6732000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1491152423000 | 1491162581000 | 10158000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1475615785000 | 1477142210000 | 1526425000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484364816000 | 1484372492000 | 7676000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484481430000 | 1484509282000 | 27852000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1484549282000 | 1484871176000 | 321894000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1487651142000 | 1487672250000 | 21108000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1489938042000 | 1489947740000 | 9698000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421999075563264 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1333208228000 | 1333400436000 | 192208000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
13557 | 36 | 36 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651580595579000 | 651580758871000 | 163292000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
13557 | 38 | 38 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651598161007000 | 651598870179000 | 709172000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
13557 | 15 | 15 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651441621933000 | 651442262264000 | 640331000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
13557 | 19 | 19 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651443565957000 | 651443679069000 | 113112000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
13557 | 21 | 21 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651444127664000 | 651444639374000 | 511710000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
13557 | 23 | 23 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651445216784000 | 651445444505000 | 227721000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
13557 | 26 | 26 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651452288654000 | 651453104538000 | 815884000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 25 | STATEMENT | |
13557 | 30 | 30 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651570687284000 | 651571163281000 | 475997000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 29 | STATEMENT | |
13557 | 32 | 32 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651575645609000 | 651576246447000 | 600838000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
13557 | 34 | 34 | transaction | COMMITTED | 421999075564136 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651579133895000 | 651579319619000 | 185724000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
13559 | 7 | 7 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651586400297000 | 651586434324000 | 34027000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 6 | STATEMENT | |
13559 | 9 | 9 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651586753320000 | 651586798977000 | 45657000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 8 | STATEMENT | |
13559 | 11 | 11 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651587407121000 | 651588083888000 | 676767000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 10 | STATEMENT | |
13559 | 13 | 13 | transaction | COMMITTED | 421999075565008 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 651588713340000 | 651588958819000 | 245479000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 12 | STATEMENT |
|