in|1|set global innodb_flush_log_at_trx_commit=0| in|1|set global max_connections=1000| in|1|set global table_cache=50| in|1|set global concurrent_insert=2| in|1|flush tables| in|1|set global query_cache_size=10*1024*1024| in|1|set global query_cache_type=1| in|1|set global thread_cache_size=100| in|1|reconnect| in|1|drop table if exists t1| in|1|drop table if exists t2| in|1|drop table if exists t3| in|1|create table t1(id bigint unsigned not null auto_increment primary key,data1 varchar(500),data2 bigint,data3 tinytext,index(data1),index(data2))default character set utf8 engine=myisam| in|1|create table t2(id bigint unsigned not null auto_increment primary key,data1 varchar(500),data2 bigint,data3 tinytext,index(data1),index(data2))default character set utf8 engine=myisam| in|1|create table t3(id bigint unsigned not null auto_increment primary key,data1 varchar(500),data2 bigint,data3 tinytext,index(data1),index(data2))default character set utf8 engine=myisam| n|1|set names utf8 #plain insert n|15|insert into t1(data1,data2,data3) values ('?',?,'?')|utf8,smallint,utf8 n|15|insert into t2(data1,data2,data3) values ('?',?,'?')|utf8,smallint,utf8 n|15|insert into t3(data1,data2,data3) values ('?',?,'?')|utf8,smallint,utf8 #n|1|insert delayed into t1(data1,data2,data3) values ('?',?,'?')|char,smallint,char #n|1|insert delayed into t2(data1,data2,data3) values ('?',?,'?')|char,smallint,char #n|1|insert delayed into t3(data1,data2,data3) values ('?',?,'?')|char,smallint,char #simple select count(*) n|5|select count(*),max(id) from t1; n|5|select count(*),max(id) from t2; n|5|select count(*),max(id) from t3; #some selects n|1|select min(id) from t1| n|1|select min(id) from t2| n|1|select min(id) from t3| n|1|select sum(id) from t1| n|1|select sum(id) from t2| n|1|select sum(id) from t3| #simple update of 20th of the table n|5|update t1 set data1='?' where id mod 200 = 0|char n|5|update t2 set data1='?' where id mod 200 = 0|char n|5|update t3 set data1='?' where id mod 200 = 0|char n|1|update t1,t2,t3 set t1.data3='?' where t1.id=t2.id and t2.id=t3.id|utf8 n|1|update t1,t2,t3 set t2.data3='?' where t1.id=t2.id and t2.id=t3.id|utf8 n|1|update low_priority t1,t2,t3 set t3.data3='?' where t1.id=t2.id and t2.id=t3.id|utf8 #normal select of indexed column n|5|select * from t1 where id mod 500 = 0| n|5|select * from t2 where id mod 500 = 0| n|5|select * from t3 where id mod 500 = 0| #normal select of three tables n|5|select * from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id and t1.id mod 200=0| n|5|select t3.id,t1.data3 from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id and t1.id mod 10=0 limit 100| n|5|select t1.id from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id and t1.id mod 5=0 limit 1000| #normal delete from each table n|1|delete from t1 where id mod 100=0 order by id desc limit 10| n|1|delete from t2 where id mod 100=0 order by id desc limit 10| n|1|delete quick from t3 where id mod 100=0 order by id desc limit 10| #multi table delete n|1|delete t1 from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id and t1.id mod 1000=0| n|1|delete t2 from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id and t2.id mod 1000=0| n|1|delete quick t3 from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id and t3.id mod 1000=0| #insert into select .. n|1|insert into t1(data1,data2,data3) select data1,data2,data3 from t2 order by data2 limit 5| n|1|insert into t2(data1,data2,data3) select data1,data2,data3 from t1 order by data2 limit 5| n|1|insert into t3(data1,data2,data3) select data1,data2,data3 from t2 order by data2 limit 5| #simple subquery delete n|1|delete from t1 where id =(select id from t2 order by data1 limit 1)| n|1|delete from t2 where id =(select id from t1 order by data1 limit 1)| n|1|delete from t3 where id =(select id from t2 order by data1 limit 1)| #simple update with subqueries n|1|update t1 set data3=(select data3 from t2 where id=(select max(id) from t2)) limit 5| n|1|update t2 set data3=(select data3 from t1 where id=(select max(id) from t1)) limit 5| n|1|update t3 set data3=(select data3 from t2 where id=(select max(id) from t2)) limit 5| n|1|kill query| n|1|kill connection| n|1|changeuser|