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.