1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
use data_dictionary; select * from INNODB_TRX; show create table INNODB_TRX; # Make sure we don't hit a bad assert() with an empty transaction connect (con1,localhost,root,,); connect (con2,localhost,root,,); connection con1; use test; create table t1 (a int); start transaction; connection con2; sleep 0.1; select TRX_STATE,TRX_QUERY from data_dictionary.INNODB_TRX; |