Weber Kettle Club Forums

What's Going On => Website Issues & Suggestions => Topic started by: G$ on August 13, 2013, 08:44:02 AM

Title: Slow forum response times?
Post by: G$ on August 13, 2013, 08:44:02 AM
Has anyone else experienced very slow and slightly intermittent response times from the forum over the last 24 hours?

I suspect this is self inflicted, as it seems to be tied to a browser upgrade I just performed, but the response time issues have been confined to the WKC. 
Title: Re: Slow forum response times?
Post by: G$ on August 13, 2013, 08:52:02 AM
Doing some testing, the problem is specifically with posting/replying to messages. Very weird.
Title: Re: Slow forum response times?
Post by: G$ on August 13, 2013, 08:52:16 AM
And intermittent.
Title: Re: Slow forum response times?
Post by: Bob BQ on August 13, 2013, 11:05:29 AM
Could be a problem between the chair and the keyboard...  ;)
Title: Re: Slow forum response times?
Post by: kendoll on August 13, 2013, 03:02:04 PM
Quote from: Bob BQ on August 13, 2013, 11:05:29 AM
Could be a problem between the chair and the keyboard...  ;)

Layer 8 issue, eh?  ;)

Ken
Title: Re: Slow forum response times?
Post by: G$ on August 13, 2013, 03:29:56 PM
Could be, I suppose.
Title: Re: Slow forum response times?
Post by: jcnaz on August 13, 2013, 05:32:19 PM
YES!! I had a terrible time getting messages to post last weekend.
Title: Re: Slow forum response times?
Post by: pbe gummi bear on August 13, 2013, 10:39:37 PM
I've never seen an issue. Let us know if you can reproduce it.
Title: Slow forum response times?
Post by: bob hope on August 14, 2013, 05:24:32 AM
Are we sure it's not an "ID 10 T" problem?? ;) :)
Title: Re: Slow forum response times?
Post by: Troy on August 14, 2013, 12:10:43 PM
the database has grown large.

anytime there is an update (new posts, replies, edits) - the database gets locked so no other process or person can make changes.

these locks are slower than the reads. when there are several locks queued up, it slows things down.
at peak times, the lock times have been getting slower and slower.

i'm planning some database maintenance this week.
things should be resolved when I move to the new server - but I don't know if that will happen within the next month or not.