« previous next »
Pages: 1 2 [3]  All

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

0 Members and 6 Guests are viewing this topic.

Offline Dizzy

  • Captain
  • *
  • Posts: 6179
Re: MySQL stress test this (week/) weekend!
« Reply #40 on: November 29, 2004, 03:44:31 pm »
What r sounds text files?
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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)
Logged

Offline Dizzy

  • Captain
  • *
  • Posts: 6179
Re: MySQL stress test this (week/) weekend!
« 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?
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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.)
« Last Edit: November 29, 2004, 05:18:36 pm by Bonk »
Logged

Offline RazalYllib

  • Imperial Romulan Information Service-senior advisor
  • Lt.
  • *
  • Posts: 784
  • Gender: Male
    • IRIS
Re: MySQL stress test this (week/) weekend!
« 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.


 
Logged
Comes a time when the blind man takes your hand
Says "don't you see?"
Gotta make it somehow
On the dreams you still believe
Don't give it up
You got an empty cup
Only love can fill
Only love can fill

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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.
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« Reply #46 on: November 30, 2004, 09:33:06 pm »
A bump for the info.
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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!
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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!
Logged

Offline benbean

  • Lt. Junior Grade
  • *
  • Posts: 140
  • Gender: Male
Re: MySQL stress test this (week/) weekend!
« Reply #49 on: December 03, 2004, 07:39:25 am »
How did last nights test go?
Logged
ben.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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?  ;D) If I have time for tonight I will reset it with some settings changes and some missions pulled.
Logged

Offline benbean

  • Lt. Junior Grade
  • *
  • Posts: 140
  • Gender: Male
Re: MySQL stress test this (week/) weekend!
« 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  :smackhead:
« Last Edit: December 03, 2004, 09:53:44 am by benbean »
Logged
ben.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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.
Logged

Offline KBF-Crim

  • 1st Deacon ,Church of Taldren
  • Global Moderator
  • Commodore
  • *
  • Posts: 12271
  • Gender: Male
  • Crim,son of Rus'l
Re: MySQL stress test this (week/) weekend!
« Reply #53 on: December 03, 2004, 01:08:58 pm »
I'll try and make it tonight.... :)
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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.
Logged

Offline KBFLordKrueg

  • Commander
  • *
  • Posts: 3733
  • KBF CO
Re: MySQL stress test this (week/) weekend!
« 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... :P
Are you going to put at least the SFB server back up anytime soon?
Logged
Lord Krueg
KBF CO
We are the Dead

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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!  ;D And War Cruiser Hell, and SG4, and GW5... (maybe we'll get to have em on SQL?)
Logged

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: MySQL stress test this (week/) weekend!
« 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).
Logged

Offline KBF-Kurok

  • Lt.
  • *
  • Posts: 829
  • Gender: Male
Re: MySQL stress test this (week/) weekend!
« Reply #58 on: December 04, 2004, 03:47:42 pm »
there  were 6 of a  a while ago and the server  seemed stable
Logged
Pages: 1 2 [3]  All
« previous next »