[17-June-2008] RAM upgrade to the DB server

by **Twill** on Tue Jun 17, 2008 1:09 pm

Some of you may have noticed some more downtime this morning, but unlike the weekend's downtime, this was good downtime.

Over the last few weeks, we've watched the load on the database server slowly creeping up as more and more people join the site and new plugins begin eating up extra DB queries. There was still plenty of growing room and nobody should have noticed any slowdowns, but everyone who remembers March will remember how painful a slow DB server can be.

To make sure we don't have to go through that again, CC now has 4GB more RAM in the DB box, bringing the total up to 12GB.

If you're going to add capacity, you might as well add capacity for 10,000-15,000 new active members, right?

Lackattack is also working with plugin developers to bring down their resource usage a bit and make their process requests more efficient.

All in all, this essentially means that you should see absolutely no difference from yesterday.
Thankfully it also means that you will see absolutely no difference tomorrow, and hopefully ever.

Thanks to all of you for making CC what it is. Without you, we wouldn't need more power in our servers. Spread the word and lets see how fast we can use up the RAM (in a good way!)

by **lozzini** on Tue Jun 17, 2008 1:22 pm

thanks a bunch for the continued effort in keeping this amazing site up, without you lot i would have a social life :lol:

you deserve all the thanks you get

by **spearfish** on Tue Jun 17, 2008 5:22 pm

This is great!

by **muy_thaiguy** on Tue Jun 17, 2008 5:46 pm

Then what was that just a moment ago?

by **hwhrhett** on Tue Jun 17, 2008 5:50 pm

muy_thaiguy wrote:Then what was that just a moment ago?

YOU SAW NOTHING!!!

by **alcazar** on Tue Jun 17, 2008 5:53 pm

Do I go ahead and extend my membership for 2010 too ? =D>

by **Twill** on Tue Jun 17, 2008 5:57 pm

Hey folks,

Slight crash leftover from the weekend.

Check the post here

Twill

by **Pedronicus** on Tue Jun 17, 2008 6:04 pm

Half of the time - I get the feeling that lack's idea of a memory upgrade involves wiring up 6 of these...

by **The Fuzzy Pengui** on Tue Jun 17, 2008 6:05 pm

Thanks, always great to see another upgrade. Shows how much the site is growing, and that you care about us customers

There is just one thing tho....

Twill wrote:lets see how fast we can use up the RAM

by **kj11aw** on Tue Jun 17, 2008 9:12 pm

is anyone else having SERIOUS problems with CC right now? everytime i try to do ANYTHING in a game i get the "communication with the server has timed out" message. taking me about 10 minutes to do a turn.

f*$&in annoying

by **Twill** on Tue Jun 17, 2008 11:49 pm

If you're still seeing slowing, could you post it in the suggestion and bug reports forum?

It may have been table repairs and database recovery still left over from this weekend.

Twill

by **lexie3000** on Wed Jun 18, 2008 8:09 pm

timeouts, error reports, and a new one - being locked out. am still managing to play turns but with difficulty. all very clunky and I wouldn't even attempt a complicated move unless I really had to. keep working on it twill. =D>

by **Hrvat** on Thu Jun 19, 2008 5:46 am

lexie3000 wrote:timeouts, error reports, and a new one - being locked out. am still managing to play turns but with difficulty. all very clunky and I wouldn't even attempt a complicated move unless I really had to. keep working on it twill.

same here.
Timed out 3 times while trying to make one move.
Very slow, as well.
:?:

by **yeti_c** on Thu Jun 19, 2008 6:18 am

Pedronicus wrote:Half of the time - I get the feeling that lack's idea of a memory upgrade involves wiring up 6 of these...

I own something very similar... but slightly older...

It had the same tape player as above - but in uber cool charcoal grey.

C.

by **Tense** on Thu Jun 19, 2008 7:13 am

How many database queries per second is the server normally handling?

Would be intressting to know. =P~

by **Hound** on Thu Jun 19, 2008 8:56 am

Still getting timeouts here as well.

by **Twill** on Thu Jun 19, 2008 3:32 pm

Hey folks, if you're still getting timeouts could you post them over in the Suggestions and Bug Reports forum so that we can track them properly?

Thanks

by **gdeangel** on Thu Jun 19, 2008 6:21 pm

Possible translation: the new features (i.e., plug-in's) are resource hogs?

Just imagining the number of queries needed to determine "unique opponents" for purposes of medals makes me think it's sort of a recursive problem, so why not just adjust your medals criteria to something that is not so resource intensive. I mean, reality is that saying you've beaten 400 unique players is a nice thing, but it seems to be generally agreed that playing more games will eventually get everyone there at some point.