The thing is that lately with more people in...i got some serious desyncs and delays....Like 2min waiting for a car to spawn at the traders.
I've been trying to tweak everything that has to do with network/mysql settings....
I got a monster server from hetzner
Intel® Xeon® E3-1270 v3 Quad-Core Haswell Hyper-Threading-Technology 32 GB ECC RAM 1 GBit/s-Port 200 MBit/s max guaranteed
and i have MYSQL 5.5 installed.
Now, my various questions are categorized :P
MYSQL
Because i dont know this setting....has anyone used the my-huge.ini instead of the my.ini ? And if yes, dont you have to add stuff to it ?
I mean for example, there is no character-set-server=utf8 setting in it ?
BASIC.CFG
This has been beaten to death in other threads...i know, and from what i see...there is no 'standard' settings even for the same type of machine and network capabilities....It also depends on the number of Objects in the database and number of scripts and the above MYSQL settings....which is why i have to break this in some subcategories
Scripts
- When we say number of scripts...does that mean (besides scripts that run in a while loop)...scripts in general ? Like the actual size of the mission.pbo ?
Someone suggested to move the files to the server....How is that going to affect anything ? The scripts are still there...why would it help on desyncs and stuff. And does it really matter if i have a ton of scripts that are NOT so system resources hogging monsters ? Things that are not active all the time but activated when needed and then exit ? Something like the players_build.sqf
Database
- Objects in the database.....Currently i have 9500 objects in the db.....which is nothing...compared to the 20k i had on the last server. Which are more problematic ? Buildings or Vehicles?
Actual Settings in the .cfg file
- MinBandwidth................Since hetzner guarantees 200mb (although i doubt this is the minimum....that means i have to set mine to : 204800 ?
- MaxBandwidth................I guess this must be 1073741824 since thats 1gb...right?
- MaxMsgSend.................No idea..If i use the standard mysql.ini, then 256 ? And what about if i use the my-huge.ini ?!?
- MaxSizeGuaranteed......Same as above...512 ?
- MinErrorToSendNear......0.039999992
- MinErrorToSend.............0.0029999993;
- MaxSizeNonguaranteed...256; ?!?!?
Again....all the above for a server like hetzner's.
The usual errors i am getting.....but i am not sure to what 'tweak' needs to be done to fix them:
3:00:36 NetServer::SendMsg: cannot find channel #1208017736, users.card=27 3:00:36 NetServer: users.get failed when sending to 1208017736 ----------- 3:07:01 Client: Remote object 28:5 not found 3:07:01 Server: Object 28:5 not found (message 221) ----------- 4:38:07 No player found for channel 1364146768 - message ignored
I am a bit of a error-free freak...I dont have a single error in my files that comes out of a broken script or something...So everything i could do to optimize the server (besides removing scripts) has been done....All my desyncs and lags are basically the above settings....but they are too technical for me...I am a software engineer....the hardware crap is just pissing me off :P
Any input would be really appreciated it, especially about the mysql settings, since i know i can do better there.
@Defent hjalpa mig, fi fan, lol