I'm excited I just discovered a way to remove unused MySQL indexes and I wanted to share it with you guys.

I'm following the tutorial here: https://www.percona.com/blog/2012/06/30/find-unused-indexes/

We happened to have already been using a Percona-fork of MySQL. It just so happens that Percona has been our database consultants for over a decade.

Either way, I've been trying to figure out how to do this for awhile now, and so I'm a bit excited and wanted to share. That, and the fact that I'm working on some backend stuff that required me to start a new article in order to test it out.

Recommended Answers

All 2 Replies

Did that help with your insert performance issue?

Nope, it helped with something else. It ended up working, but I'm still having the issue I posted in the other thread regarding the articles_read table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.