In this post, I am sharing a script to find the Index Usage Statistics of MySQL. This is a handy script for DBAs for finding the usage of indexes, and they can also take a decision to remove the unused indexes from the database server. Below are two different scripts: First, using SHOW INDEX: [crayon-6638949363426829879398/] … Continue reading MySQL: Script to find Index Usage Statistics of a Database