Comment 3 for bug 1642751

For the last two queries:

events_transactions_current -> https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html

mysql> UPDATE setup_consumers SET ENABLED='YES' WHERE NAME LIKE '%events_transactions%';

In one session run:

use test;
create table t1 (id int) engine=innodb;

set autocommit=0;
start transaction;
insert into t1 values (1);

In another session, run the first query:

select t.processlist_id, et.* from performance_schema.events_transactions_current et join performance_schema.threads t using(thread_id)\G
*************************** 1. row ***************************
                 processlist_id: 1878
                      THREAD_ID: 1903
                       EVENT_ID: 13
                   END_EVENT_ID: NULL
                     EVENT_NAME: transaction
                          STATE: ACTIVE
                         TRX_ID: NULL
                           GTID: AUTOMATIC
                  XID_FORMAT_ID: NULL
                      XID_GTRID: NULL
                      XID_BQUAL: NULL
                       XA_STATE: NULL
                         SOURCE: transaction.cc:209
                    TIMER_START: 2906342199742000
                      TIMER_END: 3219870413619000
                     TIMER_WAIT: 313528213877000
                    ACCESS_MODE: READ WRITE
                ISOLATION_LEVEL: REPEATABLE READ
                     AUTOCOMMIT: NO
           NUMBER_OF_SAVEPOINTS: 0
NUMBER_OF_ROLLBACK_TO_SAVEPOINT: 0
    NUMBER_OF_RELEASE_SAVEPOINT: 0
          OBJECT_INSTANCE_BEGIN: NULL
               NESTING_EVENT_ID: 12
             NESTING_EVENT_TYPE: STATEMENT
1 row in set (0.00 sec)

-- note that the state should be ACTIVE

then, go back to the first session, and run:

mysql> commit;

and run the second query:

select t.processlist_id, et.* from performance_schema.events_transactions_current et join performance_schema.threads t using(thread_id)\G
*************************** 1. row ***************************
                 processlist_id: 1878
                      THREAD_ID: 1903
                       EVENT_ID: 13
                   END_EVENT_ID: 15
                     EVENT_NAME: transaction
                          STATE: COMMITTED
                         TRX_ID: NULL
                           GTID: AUTOMATIC
                  XID_FORMAT_ID: NULL
                      XID_GTRID: NULL
                      XID_BQUAL: NULL
                       XA_STATE: NULL
                         SOURCE: transaction.cc:209
                    TIMER_START: 2906342199742000
                      TIMER_END: 3245593266177000
                     TIMER_WAIT: 339251066435000
                    ACCESS_MODE: READ WRITE
                ISOLATION_LEVEL: REPEATABLE READ
                     AUTOCOMMIT: NO
           NUMBER_OF_SAVEPOINTS: 0
NUMBER_OF_ROLLBACK_TO_SAVEPOINT: 0
    NUMBER_OF_RELEASE_SAVEPOINT: 0
          OBJECT_INSTANCE_BEGIN: NULL
               NESTING_EVENT_ID: 12
             NESTING_EVENT_TYPE: STATEMENT
1 row in set (0.00 sec)

-- note that the state should be COMMITTED