CPU Quota

Mr. Flay · Post Post #25 (ISO) » Wed Feb 14, 2007 6:39 am

Just got one of these about 10 minutes ago...any optimizations possible?

ISO · Post Post #26 (ISO) » Wed Feb 14, 2007 7:10 am

Argh. It was doing relatively well the past few days, too.

Looking at the logs, it seems we've had one CPU Quota error most days, caused primarily by one extremely slow MySQL query. Yesterday, that query was a search one - I could understand those being slow (but on the other hand, they're obviously not

that

slow

all

the time, or we'd have CPU Quota errors constantly... and that totally sounds like WIFOM, doesn't it

).

Today, we've already had three, and none of them were caused by just one MySQL query, but several not-quite-so-slow-but-still-slow ones, and most of these queries are just routine forum stuff (loading a page and what not).

bluehost will not be getting a valentine today. I'll yell at them some more when I get a chance.

Mr. Flay · Post Post #27 (ISO) » Wed Feb 14, 2007 8:37 am

I've said it before and I'll say it again, but I believe bluehost is the play for today.

Confirm Vote: bluehost

(p.s. Thanks mith for the quick answer!)

GreenLiquid · Post Post #28 (ISO) » Mon Feb 19, 2007 9:22 am

Just got another.

EDIT:

ANOTHER

about 4 minutes later.

mathcam · Post Post #29 (ISO) » Mon Feb 19, 2007 9:49 am

Yeah, I've been getting these all day.

Cam

Fircoal · Post Post #30 (ISO) » Mon Feb 19, 2007 10:03 am

I've been getting some lately.

Glork · Post Post #31 (ISO) » Mon Feb 19, 2007 10:09 am

Fircoal wrote:I've been getting some lately.

I haven't gotten any lately.

Oh, wait.... we're talking about CPU Quota errors...

petroleumjelly · Post Post #32 (ISO) » Mon Feb 19, 2007 10:36 am

So that's why Glork was posting in the "Help!" section. Was wondering...

Mr Stoofer · Post Post #33 (ISO) » Mon Feb 19, 2007 9:58 pm

Odd that this is still happening while spectrumvoid is away...

EmpTyger · Post Post #34 (ISO) » Tue Feb 20, 2007 6:31 am

Just received this error, if it still needs reporting.

Glork · Post Post #35 (ISO) » Tue Feb 20, 2007 6:36 am

EmpTyger wrote:Just received this error, if it still needs reporting.

You probably

caused

it, you dirty Tyger! >=[

Mr Stoofer · Post Post #36 (ISO) » Tue Feb 20, 2007 6:36 am

spectrumvoid is back...

spectrumvoid · Post Post #37 (ISO) » Tue Feb 20, 2007 9:38 pm

I got it continously for the 2 days I was around but posting only short posts. It was so bad I had to request replacement for 2 games because I simply could NOT reread the games... it hit everytime I was at page 14 or so.

I got online yesterday at 1.08 am, posted in 2 games, and got hit again. Ditto this morning at 11.07.

spectrumvoid · Post Post #38 (ISO) » Tue Feb 20, 2007 9:38 pm

How long does it last? I tried waiting for around 10 minutes the first couple of times I got it, then I gave up.

EmpTyger · Post Post #39 (ISO) » Tue Feb 27, 2007 6:44 am

Just received again...

Zindaras · Post Post #40 (ISO) » Tue Feb 27, 2007 6:56 am

It lasts a minute or ten for me. It happens way too damn often, too.

Mr. Flay · Post Post #41 (ISO) » Tue Feb 27, 2007 7:21 am

Usually 2-5 minutes for me, now...it used to be much longer, so I just go and do something else.

Also, if you use Firefox, the Back button is MUCH better at saving your edit/post content when this hits...

jeep · Post Post #42 (ISO) » Tue Feb 27, 2007 7:30 am

I guess I'm not online at peak times. I haven't seen this since the switchover.

-JEEP

bigAl · Post Post #43 (ISO) » Tue Feb 27, 2007 7:34 am

Just got it for ~7 minutes.

Kelly Chen · Post Post #44 (ISO) » Tue Feb 27, 2007 7:37 am

Mr. Flay wrote:Usually 2-5 minutes for me, now...it used to be much longer, so I just go and do something else.

Also, if you use Firefox, the Back button is MUCH better at saving your edit/post content when this hits...

I'm in the habit of doing a Ctrl+End, Ctrl+Shift+Home, Ctrl+C before sending anything.

LyingBrian · Post Post #45 (ISO) » Tue Feb 27, 2007 7:41 am

just got this a few minutes ago trying to log in...

Mr. Flay · Post Post #46 (ISO) » Tue Feb 27, 2007 7:44 am

Kelly Chen wrote:
Mr. Flay wrote:Usually 2-5 minutes for me, now...it used to be much longer, so I just go and do something else.

Also, if you use Firefox, the Back button is MUCH better at saving your edit/post content when this hits...
I'm in the habit of doing a Ctrl+End, Ctrl+Shift+Home, Ctrl+C before sending anything.

Ctrl+A, Ctrl+C is even faster.

bird1111 · Post Post #47 (ISO) » Tue Feb 27, 2007 7:45 am

Kelly Chen wrote:
Mr. Flay wrote:Usually 2-5 minutes for me, now...it used to be much longer, so I just go and do something else.

Also, if you use Firefox, the Back button is MUCH better at saving your edit/post content when this hits...
I'm in the habit of doing a Ctrl+End, Ctrl+Shift+Home, Ctrl+C before sending anything.

Why do all of that when Ctrl+A, Ctrl+C has the exact same effect?

Glork · Post Post #48 (ISO) » Tue Feb 27, 2007 2:36 pm

I just got a CPU error... but I noticed something very odd right before it came up. I posted a reply in What's a Bodyguard? (Post 4, obviously), and when I clicked submit, the site didn't really do anything (FF indicated that it was trying to load a page, but it just sat there for about a minute). I clicked to stop the browser, and then hit the Preview button. My post showed up as having gone through in the thread preview, so I exited the thread and went to refresh the site index. When I did this, the most recent post was listed as PJ's reply (to the same thread) two minutes before. But when I went to Mafia Discussion and to the thread, I could see that I had posted. Immediately thereafter, I got a CPU error.

It seemed more-than-coincidental enough that I figured it was related. I wish I had gotten screenshots. I don't know if it'll help you (or Bluehost) pinpoint anything, but it can't hurt to post what happened.

jeep · Post Post #49 (ISO) » Tue Feb 27, 2007 3:42 pm

When you stopped it, it was probably updating the site index stuff and was just being slow. It was probably slow because we're being throttled to whatever our CPU quota is.

-JEEP