RE: Account Has Exceeded Its CPU Quota

Air Elbonia · **Reply #15 on:** September 05, 2007, 07:30:12 pm

Sorry, was making two adjustments to indexes in big tables in an effort to reduce traffic jams at hrly updates.

site should be a little better off now (as the hrly script caused a little bit of a delay in the table where aircraft are stored triggering the only, single, site driven cpu exceeded of the day, and i realized cashflow had a pretty redundant index that was easily rid of.)

dktc · **Reply #16 on:** September 05, 2007, 09:02:34 pm

We have been going down every hour for the past 5~6 hours at least. Still going down though :?

MrOrange · **Reply #17 on:** September 05, 2007, 09:18:27 pm

Oh well, maybe we should create a little side-game that you can play while the game is down. I'll create something

Air Elbonia · **Reply #18 on:** September 05, 2007, 09:37:42 pm

Quote from: "dktc"

We have been going down every hour for the past 5~6 hours at least. Still going down though :?

So we have... hmm. definitely tonight will attempt a patch to one of the more common occuring slow queries which i hope will shave a little time off of it. bloody scary to look at those cpu exceeded logs... takes forever to find the ones that actually "drove" it over the edge as it were. and usually, they're (these days) a few 2-5 second things. The most recent one as of the time of this post was a combined 30 seconds of cpu time on 8-10ish queries, and a loooot of really tiny things.

eddie · **Reply #19 on:** September 07, 2007, 03:46:15 am

maybe get a better server?

dktc · **Reply #20 on:** September 07, 2007, 03:51:13 am

Quote from: "eddie"

maybe get a better server?

The admins are looking into it. Please see Air Elbonia's post
http://stephenm.org/forum/viewtopic.php?p=11911#11911

and I know... all these links are making me dizzy as well. :wink:

eddie · **Reply #21 on:** September 07, 2007, 03:52:22 am

i was about to say it lol

eddie · **Reply #22 on:** September 07, 2007, 04:20:45 am

ok im about to call i quits.

i think in the last hour its been down more then up

clee899 · **Reply #23 on:** September 07, 2007, 04:23:20 am

Quote from: "eddie"

ok im about to call i quits.

i think in the last hour its been down more then up

Patience. It usually takes 10/15 minutes at most for me. Time to start donating money for that upgraded server i guess...

eddie · **Reply #24 on:** September 07, 2007, 04:30:27 am

Quote from: "clee899"

Quote from: "eddie"
ok im about to call i quits.

i think in the last hour its been down more then up

Patience. It usually takes 10/15 minutes at most for me. Time to start donating money for that upgraded server i guess...

hahah i offered to put it on my server cluster. dont know what more i can do

ohh well

sarcean · **Reply #25 on:** September 07, 2007, 05:58:31 am

*edited*.

sarcean · **Reply #26 on:** September 07, 2007, 06:05:28 am

*edited*

Air Elbonia · **Reply #27 on:** September 07, 2007, 06:36:34 am

Thank you sarcean.

-makes that ftp access go poof-.

eddie · **Reply #28 on:** September 07, 2007, 06:37:09 am

Quote from: "sarcean"

please take away eddies db/script access immediately

He is running scripts to give people free money..and its going to *cabbage* up the game. He is giving people from the forum (offtopic.com) free money and if you allow it to go on the game is going to get *cabbage*ed.

You shouldn't have given him access he is just running whatever code he wants

umm im eddie and i dont know what you are talking about ??

eddie · **Reply #29 on:** September 07, 2007, 06:37:41 am

noone has ever given me anything.

:confused: