SELECT * FROM `events_transactions_current`
|
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 | 14 | 14 | transaction | COMMITTED | 421147100019304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1707639658000 | 1707652000000 | 12342000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
35 | 1 | 1 | transaction | COMMITTED | 421147100018432 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 1517971622000 | 1518194334000 | 222712000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | NULL | NULL | |
9754 | 0 | 38 | transaction | COMMITTED | 421147100021048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 485005489455000 | 485005563807000 | 74352000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 37 | STATEMENT | |
11039 | 35 | 35 | transaction | COMMITTED | 421147100021920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 537502401276000 | 537502555483000 | 154207000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 34 | STATEMENT | |
10188 | 0 | 49 | transaction | COMMITTED | 421147100021048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 503253272836000 | 503253313179000 | 40343000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
11045 | 27 | 27 | transaction | COMMITTED | 421147100019304 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 537534107036000 | 537534690532000 | 583496000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 26 | STATEMENT | |
8906 | 0 | 49 | transaction | COMMITTED | 421147100024536 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451700399807000 | 451701355664000 | 955857000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
11047 | 6 | 6 | transaction | COMMITTED | 421147100021048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 537554654132000 | 537554700282000 | 46150000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 5 | STATEMENT | |
10192 | 0 | 49 | transaction | COMMITTED | 421147100023664 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 503451293049000 | 503451348149000 | 55100000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 48 | STATEMENT | |
10835 | 0 | 35 | transaction | COMMITTED | 421147100021920 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 528715782048000 | 528715925048000 | 143000000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 34 | STATEMENT | |
8910 | 0 | 15 | transaction | COMMITTED | 421147100021048 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 451434187564000 | 451434567523000 | 379959000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 14 | STATEMENT | |
11051 | 3 | 3 | transaction | COMMITTED | 421147100020176 | AUTOMATIC | NULL | NULL | NULL | NULL | handler.cc:1323 | 537540374469000 | 537540861423000 | 486954000 | READ WRITE | REPEATABLE READ | YES | 0 | 0 | 0 | NULL | 2 | STATEMENT |
|