For anyone dealing with MySQL/MariaDB performance: unused indexes are silent resource drains. They consume memory, slow down writes, and the optimizer still has to consider them.
From what I've seen in production, different teams have different periods to classify an index as unused:
- Some teams check after 30 days of non-use
- Others wait until performance issues surface (risky)
- A few go aggressive with 7-14 day windows
I wonder, how long do you wait before calling an index "unused"?
Top comments (0)