pt-duplicate-key-checker: Removes non-duplicate key
General
Escalation
General
Escalation
Description
None
Environment
None
Activity
Show:
Rainer Stumbaum January 17, 2025 at 2:08 PM
Details
Details
Assignee
Unassigned
UnassignedReporter
Rainer Stumbaum
Rainer StumbaumPriority
MediumNeeds QA
Yes
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created January 17, 2025 at 2:01 PM
Updated January 17, 2025 at 2:08 PM
No idea how to write into Description…
So here it goes:
We run pt-duplicate-key-checker on a regular basis. We added a new index - which now gets regularly removed.
Before:
KEY `idx_ts` (`ts`), KEY `idx_ts_id` (`ts` DESC,`id`)After:
KEY `idx_ts_id` (`ts`)Looks like pt-duplicate-key-checker does not take DESC into account.