Database Hardware Upgrade

Archival storage for Announcements. Peruse old Announcements here!

Moderators: Media Team, Community Team, Global Moderators

Forum rules
Please read the Community Guidelines before posting.

Database Hardware Upgrade

Postby lackattack on Tue Feb 23, 2010 9:41 pm

Unfortunately the recent database software upgrade didn't make enough difference and there have still been slow page loading times. So we've taken the next step and increased the RAM memory on the database server from 12GB to 32GB. This should definitely make things run faster for a long time to come! :P

Also on the performance front, we've replace the xml code behind the Age Of Merchants map with a more efficient version. In particular that could make a difference when using community scripts while playing games on that map.
User avatar
Private 1st Class lackattack
Retired Administrator
 
Posts: 6112
Joined: Sun Jan 01, 2006 10:34 pm
Location: Montreal, QC
Medals: 9
Standard Achievement (1) Doubles Achievement (1) Triples Achievement (1) Freestyle Achievement (1) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (1) General Achievement (2)

Re: Database Hardware Upgrade

Postby Dako on Wed Feb 24, 2010 6:52 am

Thanks again! The update was really smooth.
Image
User avatar
Colonel Dako
 
Posts: 3948
Joined: Sun Aug 26, 2007 9:07 am
Location: St. Petersburg, Russia
Medals: 116
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (2)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Battle Royale Achievement (1) Ratings Achievement (3) Tournament Achievement (14) General Achievement (24)
Clan Achievement (20) General Contribution (20)

Re: Database Hardware Upgrade

Postby samuelc812 on Wed Feb 24, 2010 6:56 am

Nice update lack :)

~Sam
User avatar
Captain samuelc812
 
Posts: 2817
Joined: Sun Dec 30, 2007 6:56 am
Medals: 69
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3)
Speed Achievement (2) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3) Battle Royale Achievement (2)
Ratings Achievement (1) Tournament Achievement (2) General Achievement (7) Clan Achievement (6) Map Contribution (4)
Tournament Contribution (11) General Contribution (8)

Re: Database Hardware Upgrade

Postby superkeener on Wed Feb 24, 2010 7:00 am

I can already notice a difference, thanks!
Image
User avatar
Major superkeener
 
Posts: 900
Joined: Sun Sep 24, 2006 11:07 pm
Location: Orion–Cygnus Arm
Medals: 64
Standard Achievement (4) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (1) Polymorphic Achievement (1) Nuclear Spoils Achievement (1)
Fog of War Achievement (3) Trench Warfare Achievement (1) Speed Achievement (2) Teammate Achievement (1) Random Map Achievement (1)
Cross-Map Achievement (3) Ratings Achievement (4) Tournament Achievement (3) General Achievement (1) Tournament Contribution (30)

Re: Database Hardware Upgrade

Postby Smalahovet on Wed Feb 24, 2010 8:01 am

Well, i dont know if its the upgrade or what, but when i try to start some speedgames, they just dissapered.

Can someone help me?
User avatar
Lieutenant Smalahovet
 
Posts: 7
Joined: Thu Oct 22, 2009 12:00 pm
Medals: 23
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Assassin Achievement (1) Manual Troops Achievement (2) Fog of War Achievement (3) Speed Achievement (3) Cross-Map Achievement (3)
Ratings Achievement (3)

Re: Database Hardware Upgrade

Postby grifftron on Wed Feb 24, 2010 9:00 am

Well i am using a slow connection here in a small city in the northern part of Thailand and its for sure a tons quicker then it was!
Thanks Lack! =D>

-griff
‹army of nobunaga› me and so many other people including people in your own clan look at you as a joke
User avatar
Major grifftron
SoC Training Adviser
 
Posts: 3221
Joined: Thu Jul 09, 2009 6:11 am
Location: Chiang Mai
Medals: 122
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (3) Freestyle Achievement (2) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (2) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Beta Map Achievement (1) Ratings Achievement (3) Tournament Achievement (8) General Achievement (14)
Clan Achievement (17) Training Achievement (3) Map Contribution (1) Tournament Contribution (30) General Contribution (3)

Re: Database Hardware Upgrade

Postby AndyDufresne on Wed Feb 24, 2010 10:08 am

Seems swell so far! Bananas to the server.


--Andy
User avatar
Corporal 1st Class AndyDufresne
Retired Administrator
 
Posts: 25473
Joined: Fri Mar 03, 2006 8:22 pm
Location: A Banana Palm in Zihuatanejo
Medals: 20
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Freestyle Achievement (1) Fog of War Achievement (1) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (3) General Achievement (4) General Contribution (2)

Re: Database Hardware Upgrade

Postby Streaker on Wed Feb 24, 2010 10:25 am

grifftron wrote:Well i am using a slow connection here in a small city in the northern part of Thailand and its for sure a tons quicker then it was!
Thanks Lack! =D>

-griff


Did you look for them in 'Join speed games' or did you look under 'Awaiting players'?
User avatar
Major Streaker
 
Posts: 448
Joined: Sun Oct 05, 2008 10:05 am
Medals: 45
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3)
Speed Achievement (3) Random Map Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (9)
General Achievement (2) Clan Achievement (3) General Contribution (1)

Re: Database Hardware Upgrade

Postby edwinissweet on Wed Feb 24, 2010 11:30 am

thank you.
Image
User avatar
Lieutenant edwinissweet
 
Posts: 1407
Joined: Thu May 10, 2007 7:59 pm
Location: cozumel
Medals: 37
Standard Achievement (4) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (3) Freestyle Achievement (3) Nuclear Spoils Achievement (1) Fog of War Achievement (3)
Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (2) Ratings Achievement (3)
Tournament Achievement (1) General Achievement (1)

Re: Database Hardware Upgrade

Postby bedub1 on Wed Feb 24, 2010 2:43 pm

32gigs of ram! Yay! If the sql database configuration is all setup properly, then the database should use all the ram and run wonderfully.
Colonel bedub1
 
Posts: 1005
Joined: Sun Dec 31, 2006 4:41 am
Medals: 10
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Freestyle Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (1) General Contribution (1)

Re: Database Hardware Upgrade

Postby AndyDufresne on Wed Feb 24, 2010 2:49 pm

Lack will be doing some additional streamlining of old game XMLs as well. I know he's got some other projects in the work for this year as well that should drastically decrease poor performance.


--Andy
User avatar
Corporal 1st Class AndyDufresne
Retired Administrator
 
Posts: 25473
Joined: Fri Mar 03, 2006 8:22 pm
Location: A Banana Palm in Zihuatanejo
Medals: 20
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Freestyle Achievement (1) Fog of War Achievement (1) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (3) General Achievement (4) General Contribution (2)

Re: Database Hardware Upgrade

Postby rdsrds2120 on Wed Feb 24, 2010 3:06 pm

Well I'm happy, I hated timing out and having to wait 10 seconds ;). Kudos,

    ---rdsrds2120
Image
User avatar
Corporal 1st Class rdsrds2120
Retired Administrator
 
Posts: 7229
Joined: Fri Jul 03, 2009 3:42 am
Medals: 90
Conquer Cup Bronze Achievement (1) Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3)
Terminator Achievement (3) Assassin Achievement (3) Manual Troops Achievement (4) Freestyle Achievement (4) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (2) Speed Achievement (4) Teammate Achievement (2) Random Map Achievement (2)
Cross-Map Achievement (3) Battle Royale Achievement (3) Ratings Achievement (3) Tournament Achievement (4) General Achievement (9)
Clan Achievement (7) Training Achievement (3) Tournament Contribution (4) General Contribution (9)

Re: Database Hardware Upgrade

Postby natty dread on Thu Feb 25, 2010 12:46 pm

It was great taking turns this morning and being able to assault more than once every minute. Thanks lack! =D>

ps. whoa, that server RAM is almost as big as my hard drive... :shock:
Image
User avatar
Sergeant 1st Class natty dread
 
Posts: 13324
Joined: Fri Feb 08, 2008 8:58 pm
Location: just plain fucked
Medals: 49
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (2)
Manual Troops Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (1) Teammate Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) General Achievement (12) Map Contribution (12) General Contribution (7)

Re: Database Hardware Upgrade

Postby iamkoolerthanu on Thu Feb 25, 2010 4:16 pm

Streaker wrote:
grifftron wrote:Well i am using a slow connection here in a small city in the northern part of Thailand and its for sure a tons quicker then it was!
Thanks Lack! =D>

-griff


Did you look for them in 'Join speed games' or did you look under 'Awaiting players'?


I think you meant to quote him:
Smalahovet wrote:Well, i dont know if its the upgrade or what, but when i try to start some speedgames, they just dissapered.

Can someone help me?



By the way, great job lack!
User avatar
Sergeant iamkoolerthanu
 
Posts: 4210
Joined: Sun Dec 31, 2006 6:56 pm
Location: looking at my highest score: 2715, #170
Medals: 99
Standard Achievement (4) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (3) Nuclear Spoils Achievement (3) Fog of War Achievement (3)
Trench Warfare Achievement (2) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (2) Cross-Map Achievement (3)
Ratings Achievement (4) Tournament Achievement (8) General Achievement (5) Clan Achievement (8) Tournament Contribution (31)
General Contribution (1)

Re: Database Hardware Upgrade

Postby Halmir on Thu Feb 25, 2010 4:52 pm

It's great to see this happening and I fully applaud it, it's made a big difference to my gaming experience.

The thing I would say is that perhaps your performance monitoring needs looking at, as this was an issue for quite a few weeks? I'd have thought with my limited technical knowledge (I'm a Project Manager, not a tech) that there are apps that can do this for you and warn when overloads are approaching.
Sergeant 1st Class Halmir
 
Posts: 232
Joined: Mon Jun 11, 2007 3:12 pm
Medals: 28
Standard Achievement (4) Doubles Achievement (2) Triples Achievement (1) Terminator Achievement (3) Assassin Achievement (2)
Manual Troops Achievement (1) Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (4) Speed Achievement (1)
Teammate Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3)

Re: Database Hardware Upgrade

Postby soundman on Thu Feb 25, 2010 5:07 pm

Awesome job! :D
User avatar
Lieutenant soundman
 
Posts: 450
Joined: Mon Feb 04, 2008 12:36 pm
Location: Washington
Medals: 49
Standard Achievement (2) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Assassin Achievement (1) Manual Troops Achievement (1) Freestyle Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (3)
Speed Achievement (1) Teammate Achievement (1) Random Map Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3)
Tournament Achievement (1) General Achievement (8) Clan Achievement (12) Tournament Contribution (1)

Re: Database Hardware Upgrade

Postby lzrman on Thu Feb 25, 2010 6:22 pm

Loads Super Fast!
User avatar
Cook lzrman
 
Posts: 235
Joined: Wed Aug 20, 2008 3:04 am
Location: Western Canada
Medals: 1
Ratings Achievement (1)

Re: Database Hardware Upgrade

Postby AndyDufresne on Thu Feb 25, 2010 10:44 pm

Halmir wrote:It's great to see this happening and I fully applaud it, it's made a big difference to my gaming experience.

The thing I would say is that perhaps your performance monitoring needs looking at, as this was an issue for quite a few weeks? I'd have thought with my limited technical knowledge (I'm a Project Manager, not a tech) that there are apps that can do this for you and warn when overloads are approaching.


Agreed there have been issues for a while, but before we wanted to make the upgrade, we wanted to exhaust all possible tweaks and setting configurations before diving in completely.

But nonetheless, hopefully this, along with a few other behind the scenes performance workings that Lack is up, should keep CC running smoothly for a while! :D


--Andy
User avatar
Corporal 1st Class AndyDufresne
Retired Administrator
 
Posts: 25473
Joined: Fri Mar 03, 2006 8:22 pm
Location: A Banana Palm in Zihuatanejo
Medals: 20
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Freestyle Achievement (1) Fog of War Achievement (1) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (3) General Achievement (4) General Contribution (2)

Re: Database Hardware Upgrade

Postby thedriver on Fri Feb 26, 2010 5:52 am

=D> =D> =D>
User avatar
Sergeant thedriver
 
Posts: 18
Joined: Wed Sep 12, 2007 6:56 am
Location: ANTWERP
Medals: 35
Standard Achievement (4) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (1) Terminator Achievement (1)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (4) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Trench Warfare Achievement (1) Speed Achievement (2) Teammate Achievement (2) Random Map Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (4)

Re: Database Hardware Upgrade

Postby jaseleo on Fri Feb 26, 2010 11:58 am

The site is currently slow as a tortoise is anything being updated at the moment 17:00 GMT
“Kill a man, and you are a murderer. Kill millions of men, and you are a conqueror. Kill everyone, and you are a god.”
Sergeant 1st Class jaseleo
 
Posts: 253
Joined: Fri Jan 12, 2007 4:00 pm
Location: Sunderland
Medals: 47
Standard Achievement (4) Doubles Achievement (4) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (3)
Assassin Achievement (4) Manual Troops Achievement (2) Freestyle Achievement (4) Fog of War Achievement (4) Speed Achievement (4)
Teammate Achievement (3) Cross-Map Achievement (3) Ratings Achievement (3) General Achievement (1) Clan Achievement (2)

Re: Database Hardware Upgrade

Postby *Pixar* on Tue Mar 09, 2010 9:44 am

WTF lack im gonna get ******* pissed if i dont get my points back


Game 6598119
Last edited by *Pixar* on Tue Mar 09, 2010 9:45 am, edited 1 time in total.
User avatar
Brigadier *Pixar*
Chatter
Chatter
 
Posts: 777
Joined: Thu Dec 13, 2007 2:15 pm
Location: high score-3853 1/10/13 Best ranked #18
Medals: 129
Conquer Cup Bronze Achievement (1) Monthly Leader Gold (1) Standard Achievement (4) Doubles Achievement (4) Triples Achievement (3)
Quadruples Achievement (3) Terminator Achievement (3) Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4)
Polymorphic Achievement (2) Nuclear Spoils Achievement (3) Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (4)
Teammate Achievement (3) Random Map Achievement (3) Cross-Map Achievement (4) Beta Map Achievement (1) Battle Royale Achievement (3)
Ratings Achievement (3) Tournament Achievement (24) General Achievement (11) Clan Achievement (15) Challenge Achievement (2)

Re: Database Hardware Upgrade

Postby Streaker on Tue Mar 09, 2010 9:45 am

Pixar wrote:WTF lack im gonna get ******* pissed if i dont get my points back


6598119


What did that player do to you?

*edit: lol, that's one happy horse...
User avatar
Major Streaker
 
Posts: 448
Joined: Sun Oct 05, 2008 10:05 am
Medals: 45
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (1) Manual Troops Achievement (2) Freestyle Achievement (2) Nuclear Spoils Achievement (1) Fog of War Achievement (3)
Speed Achievement (3) Random Map Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (9)
General Achievement (2) Clan Achievement (3) General Contribution (1)

Re: Database Hardware Upgrade

Postby *Pixar* on Tue Mar 09, 2010 9:51 am

its the stupid upgrade he tried to do but failed and somehow neutral player elminated us all but pink !!!!!!!!!!!!! either i get my points back or im playing u and u let me win till i get the points back!!!!!!!
User avatar
Brigadier *Pixar*
Chatter
Chatter
 
Posts: 777
Joined: Thu Dec 13, 2007 2:15 pm
Location: high score-3853 1/10/13 Best ranked #18
Medals: 129
Conquer Cup Bronze Achievement (1) Monthly Leader Gold (1) Standard Achievement (4) Doubles Achievement (4) Triples Achievement (3)
Quadruples Achievement (3) Terminator Achievement (3) Assassin Achievement (3) Manual Troops Achievement (3) Freestyle Achievement (4)
Polymorphic Achievement (2) Nuclear Spoils Achievement (3) Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (4)
Teammate Achievement (3) Random Map Achievement (3) Cross-Map Achievement (4) Beta Map Achievement (1) Battle Royale Achievement (3)
Ratings Achievement (3) Tournament Achievement (24) General Achievement (11) Clan Achievement (15) Challenge Achievement (2)

Re: Database Hardware Upgrade

Postby anonymus on Tue Mar 09, 2010 10:07 am

2010-03-09 10:02:25 - anonymus received 3 troops for 4 regions
2010-03-09 10:04:20 - anonymus deployed 3 troops on Vasily Chuikov

thats is wrong! it ignored my bonus.. ;/
Click image to enlarge.
image

show: BoganGod speaks the truth
User avatar
Private 1st Class anonymus
 
Posts: 1424
Joined: Tue Apr 28, 2009 10:09 am
Location: Former DDR
Medals: 110
Standard Achievement (4) Doubles Achievement (4) Triples Achievement (4) Quadruples Achievement (4) Terminator Achievement (2)
Assassin Achievement (3) Manual Troops Achievement (4) Freestyle Achievement (3) Polymorphic Achievement (1) Nuclear Spoils Achievement (3)
Fog of War Achievement (4) Trench Warfare Achievement (3) Speed Achievement (3) Teammate Achievement (2) Random Map Achievement (3)
Cross-Map Achievement (4) Beta Map Achievement (1) Ratings Achievement (4) Tournament Achievement (17) General Achievement (11)
Clan Achievement (18) Training Achievement (1) Challenge Achievement (1) Tournament Contribution (6)

Re: Database Hardware Upgrade

Postby AndyDufresne on Tue Mar 09, 2010 10:15 am

anonymus wrote:2010-03-09 10:02:25 - anonymus received 3 troops for 4 regions
2010-03-09 10:04:20 - anonymus deployed 3 troops on Vasily Chuikov

thats is wrong! it ignored my bonus.. ;/


If you've come across a bug you think, fill out a report in the Bug Report forum, and include some more details so we can look at it.


--Andy
User avatar
Corporal 1st Class AndyDufresne
Retired Administrator
 
Posts: 25473
Joined: Fri Mar 03, 2006 8:22 pm
Location: A Banana Palm in Zihuatanejo
Medals: 20
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (1)
Freestyle Achievement (1) Fog of War Achievement (1) Trench Warfare Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (3) General Achievement (4) General Contribution (2)

Next

Return to Announcement Archives

Who is online

Users browsing this forum: No registered users

cron
Login