Finding and Removing Duplicate Indexes in MySQL With Common_schema This is an off-site link.  Please review our Terms of Service for additional information.

(Ike Walker) Recently I checked a MySQL database for duplicate indexes using common_schema, and I want to share my approach. Before I get into the details, I want to define what I mean by duplicate indexes. In the past I’ve used the terms duplicate index and redundant index somewhat interchangeably, so now that I have my own definitions straight I want to write them down:

Read this article...

comments powered by Disqus