FORUM Extremely SLOW
Moderator: General Moderators
Re: FORUM Extremely SLOW
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
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
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
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
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: FORUM Extremely SLOW
I agree with ^^
Re: FORUM Extremely SLOW
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
It's been snappy so far. We'll see how that goes though.
Re: FORUM Extremely SLOW
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.
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: FORUM Extremely SLOW
Finally I can prune posts and users without delay 
Thanks for all of hard work guys!
Thanks for all of hard work guys!
- Jonah Bron
- DevNet Master
- Posts: 2764
- Joined: Thu Mar 15, 2007 6:28 pm
- Location: Redding, California
Re: FORUM Extremely SLOW
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!
Thanks!
Re: FORUM Extremely SLOW
Nice work guys 
There are 10 types of people in this world, those who understand binary and those who don't
Re: FORUM Extremely SLOW
What are the new server (or VM) params?pytrin wrote:we are on a new server! so congratulations.
There are 10 types of people in this world, those who understand binary and those who don't
Re: FORUM Extremely SLOW
2GB Ram, 100GB Disk Running as a KVM Guest
Re: FORUM Extremely SLOW
We were 2 seconds from being offline, "slow' doesn't even begin to describe itJonah Bron wrote: I didn't even realize how slow it was before
http://img715.imageshack.us/img715/5981 ... hotdwm.jpg
It would subsidize further luxuries like this.
- Jonah Bron
- DevNet Master
- Posts: 2764
- Joined: Thu Mar 15, 2007 6:28 pm
- Location: Redding, California
Re: FORUM Extremely SLOW
Would be nice... the prosilver Special Edition theme wouldn't accommodate it, but we could remove that theme.