--source include/have_log_bin.inc let $MYSQL_PORT= `SELECT @@port`; create database mysqlslap; use mysqlslap; create table mysqlslap(id bigint not null auto_increment primary key, value varchar(10)); insert into mysqlslap values (NULL, ''),(NULL, ''),(NULL, ''); set sql_log_bin=0; --let $c=1 while ($c<21) { insert into mysqlslap (value) select value from mysqlslap; --inc $c } set sql_log_bin=1; --exec mysqlslap -hlocalhost -uroot --port=$MYSQL_PORT --host=127.0.0.1 --delimiter=";" --concurrency=3000 --number-of-queries=100000000 --iterations=1 --query="set @id=floor(rand()*4000000);update mysqlslap.mysqlslap set value='A' where id=@id; " --sleep 360 select * from information_schema.processlist order by time desc limit 10;