EmergencyEMERGENCY? Get 24/7 Help Now!

How InnoDB promotes UNIQUE constraints

 | September 10, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE constraints to the role of PRIMARY KEYs. The documentation is pretty clear: [DOCS] When […]

Read More