How to determine right value for innodb_sync_array_size How do I determine the right value for innodb_sync_array_size in MySQL? We have version 5.7 deployed on AWS RDS with 32 vCPUs, and it sees about 26 concurrent threads on average. When I measure waits using:
 show engine innodb mutex, the total number of waits increases by about 143k / hour.
The MySQL documentation does say that a higher number will help with high concurrency and wait situation, but I cannot find any documentation on what to set this number and how to determine whether this will indeed help me.
This might help in understanding it more in details.