Testing MySQL 8.0.16 on Skylake with innodb_spin_wait_pause_multiplier
HammerDB
MAY 5, 2019
However in the Skylake microarchitecture (you can see a list of CPUs here ) the PAUSE instruction changed and in the documentation it says “the latency of the PAUSE instruction in prior generation microarchitectures is about 10 cycles, whereas in Skylake microarchitecture it has been extended to as many as 140 cycles.”
48 
Let's personalize your content