Member Avatar for Dani

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.

  • 2 Contributors
  • 2 Replies
  • 132 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by Dani

Recommended Answers

All 2 Replies

Member Avatar for rubberman

Did that help with your insert performance issue?

Member Avatar for Dani

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, networking, learning, and sharing knowledge.