pt-duplicate-keys, simple doubt...

Polyglot Projects Percona Toolkit
1

Hey Guys,

A simple doubt, I’ve been working on a test environment to validate the usage of pt-duplicate-keys on certain tables I think have an ugly design and many duplicate/unnecessary indexes and column’s repetitions. BTW, the information on the end of the script execution is very useful, but, I’m in doubt about the “Size Duplicate Indexes” - is this the sum(#) of duplicate indexes lines?

# ########################################################################
# Summary of indexes
# ########################################################################

# Size Duplicate Indexes 3165489 <<<<<<---- HERE!!!
# Total Duplicate Indexes 9
# Total Indexes 22
2

Hi Wagnerbianchi;

It’s an estimate in bytes of the space taken up by the duplicate indexes. There is a good explanation in a bug report where someone asked the same question:

[url]https://bugs.launchpad.net/percona-toolkit/+bug/1415646[/url]

-Scott

3

Thanks Scott!!