Slow loading traders & desync at 50.

[Defent]

Hello,

 

I've been working and tweaking my servers for a while now but I still have the same problem, which is trader menus taking 1-2+ seconds to load as well as major desync at 50+ players. I have checked the different topics on this forum, but non mention the basic.cfg settings affecting the loading time of trader menus.

 

Anyone got any solution on reducing desync at 50+ and actually not having the traders load slow as shit?

 

My rig is:

 

i7 3770

1TB 7200rpm

1gb connection 

32gb of ram

 

The machine runs 4 servers and a mysql server. 

 

My current basic.cfg:

But menus still load "slow" with this.

MinBandwidth=1097152;
MaxBandwidth=1073741824;
MinErrorToSendNear=0.029999999;
MaxCustomFileSize=0;
adapter=-1;
Resolution_Bpp=32;
3D_Performance=1;
serverLongitude=9;
serverLatitude=51;
serverLongitudeAuto=9;
serverLatitudeAuto=51;
Windowed=0;
MinErrorToSend=0.0019999994;
MaxSizeNonguaranteed=64;

[Sukkaed]

Use config based traders.

[insertcoins]

take out 

MinBandwidth=1097152;

MaxBandwidth=1073741824;

[Defent]

Use config based traders.

I heard this does not track inventory, wouldn't that make it so people can exploit the traders more easily?

 

take out 

MinBandwidth=1097152;

MaxBandwidth=1073741824;

That, in my experience, causes insane amount of desync at even low player counts. 

I will look in to adding the config based traders, but that will take a lot of time, redoing all the trader items.

[insertcoins]

That, in my experience, causes insane amount of desync at even low player counts. 

 

absolutely did wonders for my own desync

[Defent]

absolutely did wonders for my own desync

Hmm, I will attempt this next restart. Thanks

[insertcoins]

If I'm not mistaken, you can actually edit your basic.cfg "on the fly". Think MGT said that once, not sure though

[Sukkaed]

I heard this does not track inventory, wouldn't that make it so people can exploit the traders more easily?

 

Yes, only down side is that you can't control stock amounts but traders menus are instantly responsible with any server load as all traders data is loaded from mission file instead of database.

 

For desync, how many objects in your database?

[Defent]

If I'm not mistaken, you can actually edit your basic.cfg "on the fly". Think MGT said that once, not sure though

Does seem like I could do this, will wait to see if it took effect.

 

 

Yes, only down side is that you can't control stock amounts but traders menus are instantly responsible with any server load as all traders data is loaded from mission file instead of database.

 

For desync, how many objects in your database?

I will push this to my server when I'm done adding all the items needed, and I got around 5500 rows.

[Sukkaed]

I get desync issues when object count goes over 5k. I have not found any other solution than really aggressive cleaning.

[Defent]

I see, but feels abit weird to be forced to clean or wipe anytime it goes beyond 5k so I'll see what I do - cleared the player_login table, perhaps that reduced some lag.

[cen]

4 servers on that CPU is your main problem.

[Defent]

Server rarely goes above 30% cpu usage so it is not a problem as of now. I will upgrade when I get the population and reason to. There is no reason to have a beast machine if I can't get a single server to function lag free. This machine should be able to hold atleast one server. 

 

Edit: added the config traders now, took a while to config prices and add all items again but it it seems more fluent now. ~160kb more to download but may be worth it. Thanks for the idea.

[Tobias Solem]

Server rarely goes above 30% cpu usage

Check the cpu usage for each of the cores, ARMA2 server pretty much only utilizes one of the cores, so the total CPU usage isn't a very good way of measuring CPU-usage.

[Defent]

Sometimes goes above 30%, peaking 35-40%. For a single thread that is.

 

I will attempt to shut down 2 servers and see if the problem still persists at a large. 

[Defent]

Solved the problem I believe, the server contacted the database through external IP, changed it to local and it helped abit. I then cleaned the character_data table. That table was 17mb big, I cleaned it and it's 4mb now. 45+ players and no lag yet.

[raymix]

I would also suggest disabling boats in dynamic spawns and deleting some from DB that hasn't been touched and aren't owned, but that's a personal preference. I had lots of them in middle of ocean just clogging up resources for no reason.

[Defent]

Yea, I did that a while ago - deleted all dynamic spawns except like 3-4 vehicles. I'm currently cleaning most parts of the database, daily or hourly. Trying to keep it minimal. 

[icomrade]

If you are having issues with SQL data loading slowly you will need to tune your MySQL installation. The default settings are absolute trash.

https://tools.percona.com/wizard

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/

 

Edit: Note that the second link is an article from 2006, DO NOT USE THE VARIABLES FROM IT. It does offer a good explanation of how to tune your settings and what the variable do, however.

[Defent]

I've changed a lot of those variables mentioned in the 2nd link. However, I will attempt to use the wizard in your first link. Thank you.

[Friendly]

Anyone have a preferred basic.cfg?

[cen]

MaxMsgSend=192;
MaxSizeGuaranteed=512;
MaxSizeNonguaranteed=192;
MinErrorToSendNear=0.047000002;
MinErrorToSend=0.0040000002;
MaxCustomFileSize=0;
Windowed=0;
adapter=-1;
3D_Performance=1;
Resolution_W=800;
Resolution_H=600;
Resolution_Bpp=32;

[RimBlock]

An overview of the items is on the BIS Wiki page along with some tuning suggestions.

 

Anyone played around with the following options ?.  Any difference in performance ?.  Have not seen any info on why the server would need these.

3D_Performance=1;

Resolution_W=800;

Resolution_H=600;

Resolution_Bpp=32;