dbaplus Community

Sep 7, 2017 · Databases

Why MySQL 5.7 Partition Tables Slow Down Updates: Uncovering an InnoDB Lock Regression

This article explains how upgrading to MySQL 5.7.18 caused severe performance drops on partitioned tables due to a regression that locks too many rows during single‑row updates, details the reproduction steps, shows the InnoDB lock inspection, pinpoints the faulty code path, and confirms the bug with further tests.