Indexes are the essential part of most of the databases. These data structures are used to optimize the performance of database queries. But duplicate, redundant, and unused indexes can dramatically reduce performance.
In the article Duplicate, Redundant, and Invisible Indexes by Percona you’ll find small tips about finding such indexes in MySQL and I hope reduce the time of some queries.
For more useful info - subscribe to Tech Read channel.
Likes, shares and recommendations are welcome.
#databases #mysql #indexes
In the article Duplicate, Redundant, and Invisible Indexes by Percona you’ll find small tips about finding such indexes in MySQL and I hope reduce the time of some queries.
For more useful info - subscribe to Tech Read channel.
Likes, shares and recommendations are welcome.
#databases #mysql #indexes
Percona Database Performance Blog
How to Find Duplicate, Unused, and Invisible Indexes in MySQL
This tutorial shows you how to find and remove duplicate, invisible, and unused indexes in MySQL so you can improve the performance of your mySQL database.