Gameserver Crash

[blacksea]

solution

query_cache_size= > DB --- increased the total database
tmp_table_size= > DB --- increased the total database


thus I had no problem

de esta forma no tuve mas problema

how much you increased query_cache_size and tmp_table_size ?

[Gnacik]

how much you increased query_cache_size and tmp_table_size ?

Use http://mysqltuner.com/ to get ~best values. really nice script.

[blacksea]

how much you increased query_cache_size and tmp_table_size ?

Use http://mysqltuner.com/ to get ~best values. really nice script.

this i used and i got at all ok also i used and tunner-primer but i didnt got also best results in game, lag, freeze etc . i fixed now reinstalled mysql and configured manually work like a charm now.

[JavierDC]

query_cache_size= > 550
tmp_table_size= > 550

for the amount characters.sql 55000 char

[JavierDC]

Use http://mysqltuner.com/ to get ~best values. really nice script.

can not download to test

español

no puedo descargara para realizar la prueba

[JavierDC]

how much you increased query_cache_size and tmp_table_size ?

Use http://mysqltuner.com/ to get ~best values. really nice script.

not compatible with windows

[JavierDC]

Oct 6, 2009 4:15:55 PM com.mchange.v2.resourcepool.BasicResourcePool prelimCheckoutResource
WARNING: com.mchange.v2.resourcepool.BasicResourcePool@c743eb -- an attempt to checkout a resource was interrupted, and the pool is still live: some other thread must have either interrupted the Thread attempting checkout!
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1315)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at net.sf.l2j.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:220)
at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(CharSelectionInfo.java:205)
at net.sf.l2j.gameserver.network.serverpackets.CharSelectionInfo.<init>(CharSelectionInfo.java:54)
at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:318)

after 48 hours the server was running, I skip the error here again my step setup mysql, I can help

español

luego de 48 horas que el server estaba funcionando, me salto nuevamente el error aquí paso mi configuración de mysql, que me puede ayudar.

pc
Intel Xeon serie 7400
Ram 4 GB
Windows Server 2003 R2

my.ini

Code: Select all

[client]port=3306 [mysql]default-character-set=latin1 [mysqld]port=3306basedir="C:/Program Files/MySQL/MySQL Server 5.1/"datadir="C:/Program Files/MySQL/MySQL Server 5.1/Data/"default-character-set=latin1default-storage-engine=INNODBsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"max_connections=8000query_cache_size=550Mtable_cache=1520tmp_table_size=550Mthread_cache_size=38 #*** MyISAM Specific optionsmyisam_max_sort_file_size=100Gmyisam_max_extra_sort_file_size=100Gmyisam_sort_buffer_size=30Mkey_buffer_size=129Mread_buffer_size=64Kread_rnd_buffer_size=256Ksort_buffer_size=256K #*** INNODB Specific options ***innodb_data_home_dir="E:/MySQL Datafiles/"#skip-innodbinnodb_additional_mem_pool_size=6Minnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=3Minnodb_buffer_pool_size=250Minnodb_log_file_size=50Minnodb_thread_concurrency=8

[_DS_]

Double and triple check all custom stuff (or better remove it). Your server consume 8000 connections - this is horrible.
My live server mysql has only 600 connections allowed.

[EdgyAsHell]

I just wanted to mention my fix for this issue. I had accidentally moved my test server settings for server.properties accidentally into live. This put my database connections down to 50, which caused this issue once it went into development. I increased to 500 and everything is back to running smoothly. Hope this helps someone!

[Tw3ty]

i've got this error,too ..

[JavierDC]

i've got this error,too ..

http://trac.l2jserver.com/ticket/4141

[achilless]

Maybe we should add that Windows will not run an assembly? Yes and no lick of sense Windu

[_DS_]

C:\>ver
Microsoft Windows [Версия 5.2.3790]

worksforme on windows.