i|1|set global innodb_flush_log_at_trx_commit=0
i|1|drop table if exists t1,t2,t3
i|1|create table t1(a int,b int,c int,primary key (a),key(b,c))engine=innodb
i|1|create table t2(d int,e int,f int,key(d))engine=myisam
i|1|create table t3(g int,h int,i int,unique(g,h,i))engine=innodb
i|1000|replace into t2 values (?,?,?),(?,?,?),(?,?,?)|mediumint,mediumint,mediumint,mediumint,mediumint,mediumint,mediumint,mediumint,mediumint
i|1|drop table if exists innodb_lock_monitor
i|1|create table innodb_lock_monitor(a int)engine=innodb
#n|1|transaction
n|1|start transaction
n|1|commit
n|1|rollback
n|1..5|insert ignore into t1 select d,e,f from t2 where d > ? limit 10|mediumint
n|1..5|insert ignore into t1 values (?,?,?)|mediumint,mediumint,mediumint
n|1..5|insert ignore into t2 values (?,?,?)|mediumint,mediumint,mediumint
n|1..5|insert ignore into t3 values (?,?,?)|mediumint,mediumint,mediumint
n|1..5|replace into t3 select a,b,c from t1 where c > ? limit 10|mediumint
n|1..5|delete from t1 where a=?|mediumint
n|1..5|update t2 set e=?,f=? where d=? limit 10|mediumint,mediumint,mediumint
n|1..5|select count(*) from t1,t2 where a=d and b>?|mediumint
n|1..5|select count(*) from t1,t2 where a=d and b>? for update|mediumint
n|1|truncate t1
n|1|truncate t2
n|1|truncate t3