I've received a couple of different error messages recently when trying to load a page on the site, saying something about the domain having overused its CPU quota. I'll try to get a more precise error message next time it happens.
I got that yesterday about 4pm (Central US time)... hope I didn't cause that by mucking about with the wiki (doubtful, but maybe after school isn't the time to import pages).
The CPU error has more to do with lots of different things happening than with one action.
We get that error if our account uses a large percentage of CPU time (it used to say 20%, but I think it's more like 15%); probably partly to combat denial-of-service attacks, and partly to keep one site from slowing down all the other accounts on the server. It lasts for about 10-15 seconds.
I recently received an email saying they now have servers specifically for those of us who get this error frequently, but it's a significant jump in cost. Something to consider in the future, though.
I received my first one of these of the year (probably longer than that, but I don't remember exactly) this morning. Hope it wasn't caused by the new wiki updates I've been doing...
I hope so too... guess we should stop messing with the wiki for a day and see if that's what's causing it.
Looking at the logs, it looks more likely that it's something else. We're getting a big list of slowness for about 5 minutes at a time, with gaps in between (unfortunately, the gaps aren't very big). I'll look into it.
I haven't edited the new wiki in about 12-14 hours, so if the CPU quota is tallied more recently than that, it's probably okay... (and really, my 300 page loads or whatever are probably nothing in comparison to the 500-600 posts a day made in the forums).
Nearly everything in the logs is forum page loads (with the odd slow mysql query thrown in for good measure). I guess it's possible one of the edits messed something up on the server, but like I said, it's more likely something else.
I was going to suggest (after reading Flay's OCD with the Wiki) that Flay's title should have something to do with the Wiki. That was, for the first time, when I realized that "Wicked" was spelled oddly for a reason. ><
Also, I think I had a couple of those CPU Quota messages earlier this morning. Just so this post isn't totally irrelevent to the thread.
Actually, I'm going to work on the theory that continuing to mess with the wiki will show up if it's causing the problem, since we haven't had any CPU problems in ages... and I'll be getting something done to boot.
That makes sense. The last log is from around 9 (I believe the server is on the west coast). We'll see how it looks today. If nothing comes up, I'm inclined to believe it's just a temporary server hiccup - some of the queries that were taking large chunks of CPU time simply shouldn't have been. Probably worth looking into making some things more efficient anyway.
We only had the one CPU exceeded incident yesterday. As I discussed with jeep, the main culprit in that appears to have been a mysql call on the search table. Given that the query is very routine and never ever takes as long as it did that time, I still think it's most likely this is some temporary server issue. We may do some archiving just in case, though.