FORUM Extremely SLOW

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: FORUM Extremely SLOW

Post 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
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: FORUM Extremely SLOW

Post 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.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: FORUM Extremely SLOW

Post 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
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: FORUM Extremely SLOW

Post 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
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: FORUM Extremely SLOW

Post by John Cartwright »

I agree with ^^
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: FORUM Extremely SLOW

Post 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.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Re: FORUM Extremely SLOW

Post by Weirdan »

It's been snappy so far. We'll see how that goes though.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: FORUM Extremely SLOW

Post 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.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: FORUM Extremely SLOW

Post by John Cartwright »

Finally I can prune posts and users without delay :)

Thanks for all of hard work guys!
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: FORUM Extremely SLOW

Post 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!
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: FORUM Extremely SLOW

Post by VladSun »

Nice work guys :)
There are 10 types of people in this world, those who understand binary and those who don't
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: FORUM Extremely SLOW

Post by VladSun »

pytrin wrote:we are on a new server! so congratulations.
What are the new server (or VM) params?
There are 10 types of people in this world, those who understand binary and those who don't
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: FORUM Extremely SLOW

Post by Benjamin »

2GB Ram, 100GB Disk Running as a KVM Guest
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: FORUM Extremely SLOW

Post 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.
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: FORUM Extremely SLOW

Post by Jonah Bron »

Would be nice... the prosilver Special Edition theme wouldn't accommodate it, but we could remove that theme.
Post Reply