After a morning of slow query logging and cussing, a misplaced "GROUP BY" that was turning a 0.04 second query into one that took over fifteen seconds has been fixed. I'll leave the slow query log running overnight though just to make sure I didn't miss any less common ones. If you're still seeing any serious site slowdowns, let us know.
(Score: 2) by The Mighty Buzzard on Tuesday January 08 2019, @11:48PM
I figured it would take a lot more testing, tweaking, retesting, and so on or I wouldn't have waited until I had a couple days free.
My rights don't end where your fear begins.