Testing MySQL 8.0.16 on Skylake with innodb_spin_wait_pause_multiplier
HammerDB
MAY 5, 2019
Fortunately the HammerDB TPC-C/OLTP workload intentionally has a great deal of contention between threads and is therefore ideal for testing spin-locks. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. In the recent MySQL 8.0.16 model name : Intel(R) Xeon(R) Platinum 8180 CPU @ 2.50GHz. linux-glibc2.12-x86_64/data
Let's personalize your content