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 Wednesday January 09 2019, @04:27AM
It'd probably be a good idea to ditch it for all registered users, honestly. If they get their spam on we have a damned easy recourse, so there's not really a need for them. Cleanup would still be annoying but not insurmountable.
My rights don't end where your fear begins.