1set default_storage_engine='tokudb'; 2set tokudb_prelock_empty=false; 3drop table if exists t; 4select trx_id,trx_mysql_thread_id from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id()); 5trx_id trx_mysql_thread_id 6set autocommit=0; 7create table t (id int primary key); 8insert into t values (1); 9select count(trx_mysql_thread_id) from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id()); 10count(trx_mysql_thread_id) 111 12commit; 13select trx_id,trx_mysql_thread_id from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id()); 14trx_id trx_mysql_thread_id 15connect conn_a,localhost,root,,; 16set autocommit=0; 17insert into t values (2); 18select count(trx_mysql_thread_id) from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id()); 19count(trx_mysql_thread_id) 201 21connection default; 22select count(trx_mysql_thread_id) from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id()); 23count(trx_mysql_thread_id) 240 25connection conn_a; 26commit; 27connection default; 28select trx_id,trx_mysql_thread_id from information_schema.tokudb_trx where trx_mysql_thread_id in(connection_id()); 29trx_id trx_mysql_thread_id 30disconnect conn_a; 31drop table t; 32