Page 4 of 5
Re: FORUM Extremely SLOW
Posted: Wed Oct 13, 2010 5:10 am
by Eran
Several UPDATE queries requested locks and the queue quickly reached a very large size. What happens at this point is that many instances of apache are created and not released (waiting for the queries to complete), and the server takes a long time to go through the queue of requests
Re: FORUM Extremely SLOW
Posted: Wed Oct 13, 2010 5:21 am
by Benjamin
Not sure if there is a technical term for that. I always call it "stacking" when queries are accumulating faster than they are completing.
Re: FORUM Extremely SLOW
Posted: Wed Oct 13, 2010 7:12 am
by josh
I'd say just take the forums offline asap, and convert to innodb. In the meantime we're accumulating more downtime so we should just bite the bullet
Re: FORUM Extremely SLOW
Posted: Wed Oct 13, 2010 8:49 am
by mikosiko
any bullet will be taste better than the slowness ...

... I'm for the shutdown as soon as you have the plan complete and decide to move forward guys
Re: FORUM Extremely SLOW
Posted: Wed Oct 13, 2010 12:58 pm
by John Cartwright
I agree with ^^
Re: FORUM Extremely SLOW
Posted: Thu Oct 14, 2010 8:42 pm
by Eran
Well, we bit the bullet and we are on a new server! so congratulations. The database is also converted to InnoDB - that along with more RAM and CPU and hopefully those performance issues are a thing of the past. We still haven't replaced the search part, we're going to see how it performs for a week before doing anything.
Re: FORUM Extremely SLOW
Posted: Thu Oct 14, 2010 9:03 pm
by Weirdan
It's been snappy so far. We'll see how that goes though.
Re: FORUM Extremely SLOW
Posted: Thu Oct 14, 2010 9:36 pm
by Benjamin
Everything looks good on the backend. Load average is nice and low. Deletes still take a bit of time but I'm sure that's related to the queries phpBB uses or the tables not being indexed correctly. Something to dig into.
Re: FORUM Extremely SLOW
Posted: Thu Oct 14, 2010 9:41 pm
by John Cartwright
Finally I can prune posts and users without delay
Thanks for all of hard work guys!
Re: FORUM Extremely SLOW
Posted: Thu Oct 14, 2010 10:44 pm
by Jonah Bron
Woohoo! Everything is really snappy now. I didn't even realize how slow it was before; I saw the error message when everything was down.
Thanks!
Re: FORUM Extremely SLOW
Posted: Fri Oct 15, 2010 3:12 am
by VladSun
Nice work guys

Re: FORUM Extremely SLOW
Posted: Fri Oct 15, 2010 10:22 am
by VladSun
pytrin wrote:we are on a new server! so congratulations.
What are the new server (or VM) params?
Re: FORUM Extremely SLOW
Posted: Fri Oct 15, 2010 10:35 am
by Benjamin
2GB Ram, 100GB Disk Running as a KVM Guest
Re: FORUM Extremely SLOW
Posted: Fri Oct 15, 2010 3:23 pm
by josh
Jonah Bron wrote: I didn't even realize how slow it was before
We were 2 seconds from being offline, "slow' doesn't even begin to describe it

Nice work everyone. We should put google ads at the top of every page. Maybe in the giant vast blue emptiness?
http://img715.imageshack.us/img715/5981 ... hotdwm.jpg
It would subsidize further luxuries like this.
Re: FORUM Extremely SLOW
Posted: Fri Oct 15, 2010 3:34 pm
by Jonah Bron
Would be nice... the prosilver Special Edition theme wouldn't accommodate it, but we could remove that theme.