[]Jeremy said:
[]little_joe said:
I keep doing that show processlist and just see table after table locked, which I believe is the root cause of the slowdowns.
[/]
You are probably correct there. Are you running ANY modifications at all on the site? And script tweaks, hacks, addons, etc? On some of our servers, occasionally users who apply certain hacks to their forums will cause this same behavior, where you get literally dozens of locked processes, eventually bringing MySQL to it's knees. But after reverting to a stock forum, these always go away and the system goes about it's business with no issues. [/]
Hi Jeremy, we do not have any hacks installed. I have specifically foregone hacks for performance, troubleshooting, and support purposes.
The only changes I have made are insignificant - removed search from unregistered templates, put our standard footer in the ubbt_footer.tmpl.
I understand JC's point about variances in servers and components. However, as I said we never experienced any problems while running 6.3.2. The day we upgraded to 6.4.1 is the day all of the problems started.