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" &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 | tee -a $OUTDIR/res.txt<br>for i in $threadsdo<br>runid="io$io.BP${BP}.threads${i}.bpi$bpi"<br> OUTDIR=$RUNDIR/$runid mkdir -p $OUTDIR cp $0 $OUTDIR<br>echo "server: mysql8" >> $OUTDIR/params.txtecho "buffer_pool: $BP" >> $OUTDIR/params.txtecho "randtype: $randtype" >> $OUTDIR/params.txtecho "io_capacity: $io" >> $OUTDIR/params.txtecho "threads: $i" >> $OUTDIR/params.txtecho "storage: SSD" >> $OUTDIR/params.txtecho "host: `hostname`" >> $OUTDIR/params.txtecho "buffer_pool_instances: $bpi" >> $OUTDIR/params.txt
Answer 