400+ Players Lag

[Xarnoth]

Hello,

my server have 380+ players.

why laggt from 380+ players?

MaNGoS Server:

Rev 8840

Database YTDB

OS Linux Debian

* vMaps off

Deditaced Server

* 2 x Opteron 2352

* 2 x 4 x 2,1 GHz

* 16 GB RAM

* 3 x 750 GB

My Server is a Funserver, have: 2x Playermalls, 1x Custom Battleground.

Sorry for my english, pleace help!!!

[CHili]

maybe mysql conf?

[goodbadguy]

I have a similar issue using Ubuntu Linux 64bit. Seems Mysql is the problem, but I don't know why. I know if I attempt to access the character database with almost any query it lags the realm. Also, doing character backups is impossible while the realm is up because even in the first second I try it pretty much locks the entire realm until I abort. The odd thing is that I can change and backup the Mangos database without any lag at all. Can someone explain what setting in Mysql might be causing this? Thanks.

[crashuncle]

Enough RAM and some alcohol in form of Vodka is the solution for all your problems.

Seriously, we cant help you much if you don't define your problem more detailed and if you may post us your Server / SQL configurations and if needed any related logs.

Such a machine can hold 1500+ players easily with the correct configuration and MT maps patch.

[Xarnoth]

MT-Maps is already...

It leads to delays in the game

pleace help...

[nanounico]

shows my.cnf and mangosd.conf man..! whithout more data is impossible help you!

[Xarnoth]

here...

mangos.conf

http://pastebin.com/m473efb22

my.cnf

http://pastebin.com/m5496b0bb

and ...

"mysql> show status like 'Aborted_connects';

+------------------+-------+

| Variable_name | Value |

+------------------+-------+

| Aborted_connects | 5463 |

+------------------+-------+

"

[nanounico]

// Try for mangosd.conf

PlayerSaveInterval = 200000

TargetPosRecalculateRange = 5

vmap.enableLOS = 1

vmap.enableHeight = 1

MaxCoreStuckTime = 60

Compression = 1

ProcessPriority = 1

DBErrorLogFile = ""

CharLogFile = ""

LogFile = ""

UpdateUptimeInterval = 20

Network.Threads = 2

Network.OutKBuff = -1

Network.OutUBuff = 115536

Network.TcpNodelay = 1

Also You could try with this:

GridUnload = 1

GridCleanUpDelay = 3600000

// try for my.cnf

thread_stack = 196K

max_connections = 5000 # i dont know why you have so much connections, maybe is for website.

thread_concurrency = 16 # or you can put in 8

max_allowed_packet = 16M

table_cache = 4096

join_buffer_size = 4M

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 4M

myisam_sort_buffer_size = 64M

thread_cache_size = 64

query_cache_size = 256M

query_cache_limit = 16M

innodb_file_per_table=1

innodb_buffer_pool_size = 1G

innodb_additional_mem_pool_size = 32M

innodb_flush_log_at_trx_commit = 0

innodb_flush_method = O_DSYNC

innodb_table_locks = 0

Cya!

[Xarnoth]

i found not ... (my.cnf)

join_buffer_size = 4M

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 4M

myisam_sort_buffer_size = 64M

innodb_file_per_table=1

innodb_additional_mem_pool_size = 32M

innodb_flush_log_at_trx_commit = 0

innodb_table_locks = 0

u.s.w

and for some is a # in front of

sorry for my badenglish