TEst

BP=140threads=150randtype="pareto"<br>for io in 2000dofor bpi in 1 2 4 8 16 32 64do<br>echo "Restoring backup"rm -fr $DATADIRcp -r $BACKUPDIR $DATADIRchown mysql.mysql -R $DATADIR#fstrim /datafstrim /mnt/data<br>iomax=$(( 3*$io/2 ))<br>startmysql "--datadir=$DATADIR --innodb-io-capacity=${io} --innodb_io_capacity_max=$iomax --innodb_buffer_pool_size=${BP}GB --innodb_buffer_pool_instances=$bpi" &amp;sleep 10waitmysql<br><br><br># perform warmup#./tpcc.lua --mysql-host=127.0.0.1 --mysql-user=sbtest --mysql-password=sbtest --mysql-db=sbtest --time=3600 --threads=56 --report-interval=1 --tables=10 --scale=100 --use_fk=1 run |&nbsp; tee -a $OUTDIR/res.txt<br>for i in $threadsdo<br>runid="io$io.BP${BP}.threads${i}.bpi$bpi"<br>&nbsp; &nbsp; &nbsp; &nbsp; OUTDIR=$RUNDIR/$runid&nbsp; &nbsp; &nbsp; &nbsp; mkdir -p $OUTDIR&nbsp; &nbsp; &nbsp; &nbsp; cp $0 $OUTDIR<br>echo "server: mysql8" &gt;&gt; $OUTDIR/params.txtecho "buffer_pool: $BP" &gt;&gt; $OUTDIR/params.txtecho "randtype: $randtype" &gt;&gt; $OUTDIR/params.txtecho "io_capacity: $io" &gt;&gt; $OUTDIR/params.txtecho "threads: $i" &gt;&gt; $OUTDIR/params.txtecho "storage: SSD" &gt;&gt; $OUTDIR/params.txtecho "host: `hostname`" &gt;&gt; $OUTDIR/params.txtecho "buffer_pool_instances: $bpi" &gt;&gt; $OUTDIR/params.txt

Answer :smiley: