[HELP] SERVER SETTINGS

[fokys]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

Hello!I am facing lag problems on my server!
I have about 450 players online and i got complains about lags!Pack is almost clean except added NPC buffer and Event Engine from Pnx team!
I have dedicated machine with 24GB Ram and 8 core CPU!Also geodata is enebled!I guess i would have to changed gameserver_loop.sh file but i am not sure about values to put in!Can somebody suggest me good setup?
I also have 1 error on gameserver logs

Unclosed connection! Trace: sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
java.lang.RuntimeException
at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:227)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyMethod.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyInstance.invoke(Unknown Source)
at org.python.pycode.serializable._pyx1297781365560.onAdvEvent$14(__init__.py:1207)
at org.python.pycode.serializable._pyx1297781365560.call_function(__init__.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.core.PyMethod.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyObject._jcallexc(Unknown Source)
at org.python.core.PyObject._jcall(Unknown Source)
at org.python.proxies.main$Quest$424.onAdvEvent(Unknown Source)
at com.l2jserver.gameserver.model.quest.Quest.notifyEvent(Quest.java:448)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.processQuestEvent(L2PcInstance.java:1763)
at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:214)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)
at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1001)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

[SolidSnake]

Unclosed connection - use search..

[kimeraweb]

Your buffer sucks, I've tested. Kick it out and you will be lag free.

The buffer's script doesn't close mysql connection, it hold it open until player finish his task and mysql engine thinks the task is finished and close it. Works fine when your server barely keep players online (obvious). When player finish his task, new queries are done without a thread, so that is your lag and your log.

You can fix it just closing every query done.

Good luck