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

Dizzy · « **Reply #40 on:** November 29, 2004, 03:44:31 pm »

What r sounds text files?

Bonk · « **Reply #41 on:** November 29, 2004, 03:52:17 pm »

Quote from: Dizzy on November 29, 2004, 03:44:31 pm

What r sounds text files?

Assets\Sound\sounds.txt

controls voices etc. (was modified for KCW, mods may remain uninstalled or were uninstalled manually incompletely)

Dizzy · « **Reply #42 on:** November 29, 2004, 04:46:40 pm »

ok, well I didnt D/L any KCW stuff. So your stuff is stock then?

Bonk · « **Reply #43 on:** November 29, 2004, 04:57:30 pm »

This MySQL test server is pure stock - no downloads - stock files and settings is a large part of the point of this test. (the server has been up on thor with no crashes or reboots for over 41 hours straight now...). Almost all of the server settings are stock too.

Edit: This does not mean I want all servers to run stock, that's the last thing I want (look at my mods). We just need to establish a baseline, if this server will hold 25 then I'll modify the missionlist, DV shift settings, and missions probabilites for the next test. (some map and politics tweaks too?) Then on to testing on OP+, custom scripts, more advanced settings, webmaps, etc... (Psst: SFB-OP has been running just as stably on this build on MySQL too..

, but I want to load the stock test server on thor to see if it will crash on stock settings and with the edits I've made to the serverkit's SQL code.)

RazalYllib · « **Reply #44 on:** November 29, 2004, 11:26:53 pm »

mmm, where to begin..

I have unfortunately been detained last couple days or I would have been more active. Next couple are good though. Thursday is no-go same for friday.

Very nice to see you have gotten your paws on sql source...and have hopefully tweaked, I will endeaver to rally the troops, we need a REAL stress.

Has access to source shed any illumanation on the remaining undecypherable blobs?

Post stress...

If things go well, we get a chunk of warm bodies to log on and hit a single hex and is does not go "Poof" it will be a good thing.
I hope other optimization is occuring with elements of the server kit, to increase stability and perhaps player load.

I would like to see a stress of a Enormous Map as well, combined with large AI Player count. That has not been done in some time if I recall since David and Mags did some additional work on the server kit many many many moons ago. IIRC, one of the problems with HUGE maps was corruption of the flatfile db due to the size of the map, but I may be wrong, it was a while ago.

Bonk · « **Reply #45 on:** November 30, 2004, 02:04:06 am »

Quote from: RazalYllib on November 29, 2004, 11:26:53 pm

Very nice to see you have gotten your paws on sql source...and have hopefully tweaked, I will endeaver to rally the troops, we need a REAL stress.

I wish, I hope, I pray that 25 people will eventually show up...

(Castrin had found the same - the SQL kit works perfectly - nobody will play on it

unless its on a mangled mod and guaranteed to crash so they can say "We told you so..")

Quote from: RazalYllib on November 29, 2004, 11:26:53 pm

Has access to source shed any illumanation on the remaining undecypherable blobs?

Somewhat, but I have not had time to dig into it yet, as I went right for the SQL code to try and remove some of the absurdness.

Big maps are gonna make this kit barf, that's the way it is written. There is a possible complete overhaul in the works, new db, new code... patience it will be a very slow process... if we're gonna do it we'll take the time to do it right.

Bonk · « **Reply #46 on:** November 30, 2004, 09:33:06 pm »

A bump for the info.

Bonk · « **Reply #47 on:** December 02, 2004, 11:23:18 am »

Bump for tonight!

Quote from: Bonk on November 30, 2004, 02:25:21 pm

Yes, 5:00 PM Pacific or 6:00 PM Mountain or 7:00PM Central or 8:00PM Eastern or 9:00PM Atlantic, any of these will do!

Bonk · « **Reply #48 on:** December 02, 2004, 01:24:56 pm »

Another bump for tonight!

Quote from: Bonk on November 30, 2004, 02:25:21 pm

Yes, 5:00 PM Pacific or 6:00 PM Mountain or 7:00PM Central or 8:00PM Eastern or 9:00PM Atlantic, any of these will do!

benbean · « **Reply #49 on:** December 03, 2004, 07:39:25 am »

How did last nights test go?

Bonk · « **Reply #50 on:** December 03, 2004, 07:50:44 am »

Good, I got some good info, but we still did not get 25 on. (brief report here) I have a new build that I want to test tonight. (sleep, what sleep?

) If I have time for tonight I will reset it with some settings changes and some missions pulled.

benbean · « **Reply #51 on:** December 03, 2004, 07:54:22 am »

Well, the kids are going to Grandma's and the wife has her works Christmas party this Saturday. I'm at your disposal bonk.

Edit: well Mrs bean just told me that she aint going now

I'll be online still, just not as much as I thought

Bonk · « **Reply #52 on:** December 03, 2004, 01:02:10 pm »

Thanks, even a short visit to add to the numbers is a help.

Server has been reset on a new build, some settings modified and some missions missions pulled. (yay!) Hopefully we'll be able to get 25 on sometime over the weekend to see what we get this time.

KBF-Crim · « **Reply #53 on:** December 03, 2004, 01:08:58 pm »

I'll try and make it tonight....

Bonk · « **Reply #54 on:** December 04, 2004, 08:45:43 am »

The test server will have to wait. I just took it down (though I'm dying to see what happens on this build). The D.net test server is busy until further notice. I will move the test server to my server (Duron1.3-256MB) shortly and take SFB-OP down.

KBFLordKrueg · « **Reply #55 on:** December 04, 2004, 09:48:52 am »

Ah, well, that answers my question I posted in the SFB thread.
That's what I get for not looking here forst...

Are you going to put at least the SFB server back up anytime soon?

Bonk · « **Reply #56 on:** December 04, 2004, 10:14:42 am »

Sorry bout that Kreug. I took it down so I can run the MySQL test on it instead. (machine can't afford to run both for testing conditions). When I get 25 or more on the test, I'll put SFB-OP back up (hopefully sunday night or monday).

The test server is back up! So get on the test people, so we can get back to SFB-OP!

And War Cruiser Hell, and SG4, and GW5... (maybe we'll get to have em on SQL?)

Bonk · « **Reply #57 on:** December 04, 2004, 10:33:01 am »

Here's a Webmap so we can see who's on when, to help get a crowd on. (shipyard disabled so the webmap will not write to the db so as not to disturb the test).

KBF-Kurok · « **Reply #58 on:** December 04, 2004, 03:47:42 pm »

there were 6 of a a while ago and the server seemed stable

News: