how much you increased query_cache_size and tmp_table_size ?JavierDC wrote: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
Use http://mysqltuner.com/ to get ~best values. really nice script.blacksea wrote:how much you increased query_cache_size and tmp_table_size ?
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.Gnacik wrote:Use http://mysqltuner.com/ to get ~best values. really nice script.blacksea wrote:how much you increased query_cache_size and tmp_table_size ?
can not download to testGnacik wrote: Use http://mysqltuner.com/ to get ~best values. really nice script.
Gnacik wrote:Use http://mysqltuner.com/ to get ~best values. really nice script.blacksea wrote:how much you increased query_cache_size and tmp_table_size ?
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)
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