That seems wrong, innodb_io_capacity_max must always be smaller than innodb_io_capacity.
innodb_io_capacity_max: 75% of inferred max iops based on peak disk I/O stats and corresponding disk I/O saturation observed recently. Round down to nearest 500.
innodb_io_capacity: 50% of inferred max iops based on peak disk I/O stats and corresponding disk I/O saturation observed recently. Round down to nearest 500.
Never less than defaults (2000 and 200 respectively).
I'm seeing proposals that say:
That seems wrong,
innodb_io_capacity_max
must always be smaller thaninnodb_io_capacity
.innodb_io_capacity_max
: 75% of inferred max iops based on peak disk I/O stats and corresponding disk I/O saturation observed recently. Round down to nearest 500.innodb_io_capacity
: 50% of inferred max iops based on peak disk I/O stats and corresponding disk I/O saturation observed recently. Round down to nearest 500.Never less than defaults (2000 and 200 respectively).