EmergencyEMERGENCY? Get 24/7 Help Now!

check-unused-keys: A tool to interact with INDEX_STATISTICS

 | June 26, 2009 |  Posted In: Insight for DBAs

PREVIOUS POST
NEXT POST

With the growing adoption of Google’s User Statistics Patch**, the need for supporting scripts has become clear. To that end, we’ve created check-unused-keys, a Perl script to provide a nicer interface than directly querying the INFORMATION_SCHEMA database.

check-unused-keys can be invoked and used as follows:

** FULLTEXT indexes are not taken into account by this patch, so be wary. And, as always, sanity check the suggestions and test thoroughly before making changes to production.

PREVIOUS POST
NEXT POST
Ryan Lowe

Ryan was a principal consultant and team manager at Percona until July 2014. He has experience with many database technologies in industries such as health care, telecommunications, and social networking.

10 Comments

Leave a Reply