Tagged articles
2 articles
Page 1 of 1
Meituan Technology Team
Meituan Technology Team
Apr 16, 2020 · Databases

Analyzing and Optimizing MySQL Performance on Intel Skylake CPUs

Meituan’s DBA team discovered that Intel Skylake CPUs dramatically increased PAUSE‑instruction latency, causing MySQL’s ut_delay spin‑wait loops to consume most CPU cycles and reduce write throughput, and they restored performance by back‑porting MySQL 8.0’s spin_wait_pause_multiplier patch to 5.7, upgrading to CentOS 7, and moving to Cascadelake hardware.

CPULinuxdatabase
0 likes · 18 min read
Analyzing and Optimizing MySQL Performance on Intel Skylake CPUs