pt-duplicate-key-checker does not re-create indexes with same prefix length

Reported by Ryan Lowe on 2013-08-19
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Medium
Unassigned

Bug Description

See summary. Anonymized example:

# ########################################################################
# X.Y
# ########################################################################

# Key IX_Z ends with a prefix of the clustered index
# Key definitions:
# KEY `IX_Z` (`A`(13),`B`)
# PRIMARY KEY (`B`),
# Column types:
# `B` varchar(767) default null
# `A` decimal(22,0) not null
# To shorten this duplicate clustered index, execute:
ALTER TABLE `X`.`Y` DROP INDEX `IX_Z`, ADD INDEX `IX_A` (`A`);

tags: added: pt-duplicate-key-checker
Changed in percona-toolkit:
status: New → Confirmed
tags: added: index-prefix
Changed in percona-toolkit:
milestone: none → 2.2.6
importance: Undecided → Medium
assignee: nobody → Daniel Nichter (daniel-nichter)
Changed in percona-toolkit:
status: Confirmed → In Progress
Daniel Nichter (daniel-nichter) wrote :

Ryan,

Can you provide a table def that reproduce this? Column A is DECIMAL which doesn't support a prefix as far as I can tell or make MySQL accept. So I don't know how KEY `IX_Z` (`A`(13),`B`) is possible.

Changed in percona-toolkit:
status: In Progress → Incomplete
milestone: 2.2.6 → none
assignee: Daniel Nichter (daniel-nichter) → nobody
Launchpad Janitor (janitor) wrote :

[Expired for Percona Toolkit because there has been no activity for 60 days.]

Changed in percona-toolkit:
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers