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} --inno…

TEst

matthewb August 12, 2020, 12:14pm 2

Answer

Topic		Replies	Views
Performance Problems - High IO Wait Other MySQL® Questions	3	1510	May 28, 2008
Innodb Threads Settings Other MySQL® Questions	2	1221	March 14, 2011
AWS EC2 with MySQL not using anywhere near the resources available MySQL & MariaDB mysql	9	1067	August 27, 2021
Advice pls my.cnf settings for my system Other MySQL® Questions	2	736	October 6, 2007
MySQL 8.4 - Disabling InnoDB Redo Log During Restore - Safe Practice? Other MySQL® Questions	24	2342	December 24, 2024