L2J Server

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

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?

is 0 by default.

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

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.

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.

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.

check CPU & Memory ussage when that happens.

what is server internet speed ?

MELERIX wrote: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.

and startup parameters for startgame/loginserver ?

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)?