Database Hardware Upgrade

Archival storage for Announcements. Peruse old Announcements here!

Moderators: Community Team, Global Moderators, Media Team

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: 6235
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
Brigadier Dako
 
Posts: 3942
Joined: Sun Aug 26, 2007 9:07 am
Location: St. Petersburg, Russia
Medals: 115
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 (13) 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
Major samuelc812
 
Posts: 2931
Joined: Sun Dec 30, 2007 6:56 am
Medals: 67
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) 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 (5) 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!
User avatar
Major superkeener
 
Posts: 886
Joined: Sun Sep 24, 2006 11:07 pm
Location: Orion–Cygnus Arm
Medals: 63
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 (2) 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: 3189
Joined: Thu Jul 09, 2009 6:11 am
Location: Chiang Mai
Medals: 120
Standard Achievement (3) 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 (16) 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 AndyDufresne
Retired Administrator
 
Posts: 25042
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 AndyDufresne
Retired Administrator
 
Posts: 25042
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: 7220
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: 13255
Joined: Fri Feb 08, 2008 8:58 pm
Location: fucked off
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!
rds is awesome!
Image
User avatar
Private 1st Class iamkoolerthanu
 
Posts: 4184
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: 230
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)

Next

Return to Announcement Archives

Who is online

Users browsing this forum: No registered users and 1 guest

Login