Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
Often you can predict how many IOPS your system can do, especially if it has magnetic drives. Many cheap enterprise SSDs can do 4,000-10,000 IOPS etc. For example, 8 15k disks in RAID10 can do about 1000 random write IOPS, so you could have innodb_io_capacity=600 and innodb_io_capacity_max=1000.