Send News. Want a reply? Read this. More in the FAQ.   News Forum - All Forums - Mobile - PDA - RSS Headlines  RSS Headlines   Twitter  Twitter
User Settings
LAN Parties
Upcoming one-time events:

Regularly scheduled events

Report this Comment
Use this form to report the selected comment to the moderators. Reporting should generally be used only if the comment breaks forum rules.

3. Re: Out of the Blue Mar 17, 2013, 16:38 jdreyer
Redmask wrote on Mar 17, 2013, 16:22:
Any word on why the site has been experiencing large amounts of downtime?

From yesterday's Out of the Blue:

Frans wrote on Mar 17, 2013, 14:45:
We know the site hiccups are caused by MySQL locking up, which in turn causes all Apache processes to eventually get tied up, waiting for queries to complete, and making the site unresponsive.

I've spent many an hour trying to figure out why MySQL locks up, obviously without success, so in recent months Blue and I simply resorted to restarting Apache & MySQL. Because we aren't always around, some outages last up to several hours. Sorry about that.

I suspect the problem is in the forums code, as that's the only code that has actual LOCK statements (when storing a new post and updating thread counters), but I don't have enough real MySQL wizardry under my belt to understand why this can run flawlessly for days or even several weeks, and then cause multiple lockups on some days again, like this weekend.

So there you have an update.

@ Frans

So basically, the issue is being caused by Cutter posting too much?

At work we were experiencing something similar, so we added Nolocks to all of our queries. Maybe you don't need to lock? Here's an interesting article discussing alternatives and optimizations. My SQL skills are weak, but maybe there's someone on Blues has mad skills that can give advice?
Avatar 22024
Live long, and prosper.
Login Email   Password Remember Me
If you don't already have a Blue's News user account, you can sign up here.
Forgotten your password? Click here.


Blue's News logo