--source include/have_innodb.inc let $duration= `SELECT 5*60`; let $thread_count= 64; let $table_engine= InnoDB; let $table_count=4; let $table_size= 50000; --disable_query_log --disable_result_log if (`select '$RQG_HOME'=''`) { --skip Could not locate RQG - set RQG_HOME variable. } CREATE DATABASE db1; USE db1; --echo Creating $table_count tables, around $table_size rows in each. while ($table_count) { eval CREATE TABLE t$table_count (k int primary key, i int) ENGINE=$table_engine; let $size= `SELECT round($table_size*(1+2*rand())/3)`; let $size_list= $size_list $size; while ($size) { eval insert into t$table_count values ($size,1); dec $size; } dec $table_count; } let TABLE_SIZES= $size_list; --echo Running Queries against these tables in $thread_count threads for $duration seconds. #--enable_result_log let $DSN= dbi:mysql:host=127.0.0.1:port=$MASTER_MYPORT:user=root:database=db1; --exec perl $RQG_HOME/gentest.pl --threads=$thread_count --duration=$duration --dsn=$DSN --grammar jl.rqg --echo Done. DROP DATABASE db1; --exit