Not the answer you need?
Register and ask your own question!

pt-duplicate-keys, simple doubt...

wagnerbianchiwagnerbianchi Remote DBACurrent User Role Patron
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

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.