Hardware problem?

[badboy29]

More here: http://www.mysqlfaqs.net/mysql-faqs/Spe ... e-in-MySQL

[elmatig89]

Thanks, so to enable querry cache is a bad idea, reading the info that badboy shared enabling querry cache may be a slowdown. So the best should be to set query_cache_type = 0 right?

[MELERIX]

is 0 by default.

and btw, why you don't read the description in the same option inside my.ini xD

Code: Select all

# Query cache is used to cache SELECT results and later return them# without actual executing the same query once again. Having the query# cache enabled may result in significant speed improvements, if your# have a lot of identical queries and rarely changing tables. See the# "Qcache_lowmem_prunes" status variable to check if the current value# is high enough for your load.# Note: In case your tables change very often or if your queries are# textually different every time, the query cache may result in a# slowdown instead of a performance improvement.query_cache_size=0

[elmatig89]

Ok, thanks, now when the server has the problem the gatekeepers does not work, you can talk to them and the html will pop up but when you try to teleport nothing happens, and the soes doesnt work, after a few minutes everything goes to normal.

[jorgeromero]

Update your server to the latest revision and for sure the problem is solved. I have a server with 600 Online and Sieges in the 900 and we have no problems with lag. Any questions send me a PM.

Hope that helps.

[elmatig89]

Thanks, ive format and installed win server 2008 r2 64bits and i have made 25gb partitions on the HDs so they run faster, now i have 950 characters online and its working great. Thank you guys.

[JavierDC]

thanks for reopening. if I have understood, when the server exceeds a certain char connected +900 (+ - 100), the server has locked char error, or can not move and another if, spent a lot of that when the wizards are casting healing with + 1900, these are blocked, they see that others can not move and chat, sometimes also the char are blocked and disappear npc or mob, and when they are connected in another place and in a random direction, and also run off the char and can not handle. this problem is long ago, more than one thread in the forum are reporting this.

en español

gracias por abrir de nuevo. haber si me entienden, cuando el server supera determinados char conectados +900 (+ - 100), el server tiene error en char bloqueados; o no pueden moverse y los otro si, ha pasado mucho que cuando los magos se estan curando con casting + de 1900, estos se bloquean, ven que los demas se mueven y no pueden chatear, tambien aveces los char se bloquean y desaparecen los npc o mob, y cuando se conectan estan en otro lugar y en una direccion aleatoria, o tambien salen corriendo los char y no se pueden manejar. este problema esta hace mucho, en mas de un tema en el foro estan reportando esto.

[MELERIX]

check CPU & Memory ussage when that happens.

what is server internet speed ?

[JavierDC]

check CPU & Memory ussage when that happens.

what is server internet speed ?

server
http://h10010.www1.hp.com/wwpc/es/es/sm ... 84625.html

16gb ram
4 cpu

conexion 100mbps.

[MELERIX]

and startup parameters for startgame/loginserver ?

[Szponiasty]

Some packets (like enterworld) are set to "urgent" priority by default. That makes them able to affect whole packet management and broadcasting of gameserver. Lower priotities to high and check again. Chars not move but appear in other place on relogin (or suddenly start moving super fast) means that gameserver handles their movement correclty, but there is an problem with clients getting proper position/movement packets. Also there is an problem with validateposiotion packets getting to gs from clients. Those packets cant wait much time (as thats for proper syncing client - server char position live while moving, so when there is slowdown on it - gs has no proper coord dataa and does wrong position sync/skips sync completely). Check if u turned on coordsync (at least to 1, preferably to method "2" - if u have good enough geodata and connection).

Hard to guess whats exacly is wrong. For sure not an problem with cpu or database/hdd speed, but sth to do with communication between clients and server. Try increasing io thread pool and packet thread pools too - but not necessary much above default setting (try eg. for a start increasing them 2x - if u have at least 4 core cpu). U dont need to change AI pool or effects pool.

Also - does ur players experience 3-10 seconds freezes from time to time (or when move problem appears on ur server) when logging on on gameserver? All appears they see their char, but no text on chat windows, no npcs or mobs (thats on enterworld packet, which has urgent priority, and tends to easy lag whole server when few ppl log same time - like said: try reducing every packet u will find, that has urgent priotiry, to one step lower)?