3.2.5 I've Got Too Many Indexes! How Do I Know Which Ones to Drop?

3.2.5.1 Objectives
3.2.5.2 Example Execution
3.2.5.3 Discussion
3.2.5.4 Permissions Required
3.2.5.5 Tips and Tricks

MySQL allows its users to create several indexes that might be the same (duplicate indexes) or partially similar (redundant indexes) in its structure. Although duplicate indexes have no advantages, there are some cases where redundant indexes might be helpful. However, both have disadvantages. Duplicate and redundant indexes slow down update and insert operations. As a result it is usually a good idea to find and remove them.

Doing this manually would be a time consuming task, especially for big databases and that is why there is a utility to automate this type of task: mysqlindexcheck.