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 | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2810915941000 | 2810930022000 | 14081000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 12 | 12 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2811055181000 | 2811073242000 | 18061000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 13 | 13 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2811716878000 | 2811727055000 | 10177000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 14 | 14 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2811857950000 | 2811866990000 | 9040000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 5 | 5 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2763589437000 | 2765546350000 | 1956913000 | READ WRITE | REPEATABLE READ | NO | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 6 | 6 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2793951579000 | 2793978423000 | 26844000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 7 | 7 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2794253016000 | 2794352903000 | 99887000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 8 | 8 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2794480528000 | 2797102721000 | 2622193000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 9 | 9 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2804224241000 | 2804291022000 | 66781000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
1 | 10 | 10 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2809711025000 | 2809739461000 | 28436000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421892964710144 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 2494172062000 | 2494568012000 | 395950000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
555 | 38 | 38 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48616106573000 | 48616374737000 | 268164000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
555 | 40 | 40 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48641267180000 | 48641705785000 | 438605000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 39 | STATEMENT | |
555 | 15 | 15 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48481700483000 | 48482269641000 | 569158000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
555 | 19 | 19 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48483316623000 | 48483424492000 | 107869000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 18 | STATEMENT | |
555 | 21 | 21 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48483906730000 | 48484311922000 | 405192000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 20 | STATEMENT | |
555 | 23 | 23 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48484886288000 | 48485124489000 | 238201000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 22 | STATEMENT | |
555 | 27 | 27 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48496487802000 | 48497003975000 | 516173000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
555 | 32 | 32 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48597156143000 | 48597376942000 | 220799000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 31 | STATEMENT | |
555 | 34 | 34 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48601701076000 | 48602502225000 | 801149000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 33 | STATEMENT | |
555 | 36 | 36 | transaction | COMMITTED | 421892964711888 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48609689211000 | 48610000461000 | 311250000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 35 | STATEMENT | |
557 | 6 | 6 | transaction | COMMITTED | 421892964711016 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 48657512669000 | 48657558404000 | 45735000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT |
|