Topic: MySQL stress test this (week/) weekend! (Read 7029 times)

Bonk · « **on:** November 26, 2004, 10:51:16 am »

When GW4 is over Saturday midnight, I will launch a MySQL stress test. Stock files and settings will be used to eliminate errors from those sources.

This is a test build that includes some minor but potentially significant changes to the SQL code. If I see any improvement I'll continue editing the SQL code along the same lines... if not I'll look at extending the error reporting.

This will be the first in a series of a few systematic tests, do not expect immediate results, but I am feeling optimistic.

The test will be run on Thor initially (I'm working on getting a stable test environment there), If I have problems there that I believe may be due to Thor, I'll move it to my server but I hestiate because my cable connection is only 600kbit up.

Your participation is required of course and is much appreciated.

drb · « **Reply #1 on:** November 26, 2004, 04:22:55 pm »

Hoi Bonk,

Your continuing efforts are a major asset to this community. Count on me to be there.

Take care

drb

FPF-DieHard · « **Reply #2 on:** November 26, 2004, 05:47:31 pm »

Bonk, you want to just use the whole Setup from GW4 so nobody has to Download anything?

Also, any chance we can do "War Cruiser Hell" as an SQL server with you assistance?

Green · « **Reply #3 on:** November 26, 2004, 06:07:46 pm »

Quote from: FPF-DieHard on November 26, 2004, 05:47:31 pm

Bonk, you want to just use the whole Setup from GW4 so nobody has to Download anything.

Would help. If not, then what about just using the OP+ list?

KBF-Crim · « **Reply #4 on:** November 26, 2004, 06:13:44 pm »

cool beans...

drb · « **Reply #5 on:** November 26, 2004, 08:14:45 pm »

Hoi Folks,

If it is a stock setup, then there would be no downloads. Just a matter of uninstalling GW4 and OP+, or am I missing something here?

Take care

drb

Bonk · « **Reply #6 on:** November 26, 2004, 09:59:47 pm »

Correct Watson, running on stock settings is part of this test, and as an added benefit requires no downloads at all!

Bonk · « **Reply #7 on:** November 26, 2004, 10:06:35 pm »

Quote from: FPF-DieHard on November 26, 2004, 05:47:31 pm

Bonk, you want to just use the whole Setup from GW4 so nobody has to Download anything?

Also, any chance we can do "War Cruiser Hell" as an SQL server with you assistance?

As drb pointed out, no download is required for a stock test (part of my systematic approach - if successfull, I'll move on to the standard gf edits, then OP+...) But I'd be happy to try a test of "War Cruiser Hell" on SQL on the condition the shiplist and settings are in line with my testing strategy.

Bonk · « **Reply #8 on:** November 27, 2004, 03:21:01 pm »

el bumpo!

Bonk · « **Reply #9 on:** November 27, 2004, 10:49:35 pm »

I'll give thor three strikes tonight before moving it to my server, three more on mine and back to work... but I hope to see improvement.

Bonk · « **Reply #10 on:** November 27, 2004, 11:31:08 pm »

Under protest I have upped the initial PP to to 10K, it was running smooth with 8 on when I killed it. Back to the test!

stock files are available here:
shiplist: http://www.dynaverse.net/v2/downloads.php?id=21&game=SFC2%20OP#download
fighterlist: http://www.dynaverse.net/v2/downloads.php?id=20&game=SFC2%20OP#download

if necessary I can make an installer...

Bonk · « **Reply #11 on:** November 27, 2004, 11:38:39 pm »

stock missions can be found in the current serverkit:
http://www.dynaverse.net/v2/downloads.php?id=25&game=SFC2%20OP#download

Bonk · « **Reply #12 on:** November 28, 2004, 12:07:27 am »

Stock files installer: here

(edit: does not include stock strings files yet - I'll update it later...)

Bonk · « **Reply #13 on:** November 28, 2004, 01:54:56 am »

So far so good, no crashes in over 3 hours (only 8 players max tho...) - no crashes at all. I'll check in on it in the am (process sentinel is not on).

I hope to hit it again at 4 and 8 pm AST* today if everyone's willing to try and crash it, please login then!

(* edit - see below)

Soreyes · « **Reply #14 on:** November 28, 2004, 02:18:38 am »

Will be there with bells on

KAT Chuut-Ritt · « **Reply #15 on:** November 28, 2004, 02:37:10 am »

Quote from: Soreyes on November 28, 2004, 02:18:38 am

Will be there with bells on

Any one wanna ring Soreyes' bell?

Bonk · « **Reply #16 on:** November 28, 2004, 08:16:28 am »

Wow its still up!

(don't anybody touch anything on thor...just login on the test!) Have I done it? (This build is 3.00MB bang on, odd I thought, a good omen?). Looks like the kit is stable on thor, but is it stable under a full player load?

Again, I want to hit it at 4 PM and 8 PM AST* today, the server will stay up till it crashes at least once, (three strikes on thor then on my server).

(*edit - see below)

benbean · « **Reply #17 on:** November 28, 2004, 08:36:27 am »

Ok whats ADT and whats the time difference to GMT? (Greenwich Mean Time)

Bonk · « **Reply #18 on:** November 28, 2004, 08:38:47 am »

<...checks phone book>

Atlantic Standard Time (AST) = GMT-4
Atlantic Daylight Time (ADT) = GMT-3

edit - corrected - lol, I had to look here to be sure. (the time displayed there is the correct time for me, but the definitions below it should read GMT-x)

So the test times are actually 4 and 8 PM AST today, but feel free to login and check it out anytime while its up. (I intend to spend most of the day there but have to help a friend with a job search today too.)

benbean · « **Reply #19 on:** November 28, 2004, 12:20:20 pm »

1 hour 45 mins from the time on this post.

I'll be there Bonk.

News:

Topic: MySQL stress test this (week/) weekend! (Read 7029 times) var addthis_config = {"data_track_clickback":true};

Topic: MySQL stress test this (week/) weekend! (Read 7029 times)