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 Runaway1956 on Wednesday January 09 2019, @03:19AM (1 child)
I've seen both of those. Type a reply, get called away by the wife, come back and hit submit. Or change to VPN, or disconnect from VPN. Both easily solved - hit the "back" button, copy what you had typed, then reload the topic to which you were responding, hit the "reply" button again. It's a mild irritant, might really piss some other people off.
(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.