Server Freeze

[knoppix]

Also use:
ALTER TABLE `yourtables` ENGINE = innodb;

Hey!

Everything is working OK so far, i'm about to move the test to the live server, but i have just one more question about the quote i've made.

Where that exactly goes? and what do you mean with 'youtables' ?

Thanks a lot for the help , as you may figure already, i'm kinda newbie on the MYSQL configuration world =P.

P.S: Don't know if this happened to you but, the Clan Hall Warehouse doesn't "work" properly, for example, if i have 2 adena stored, and i add 2 more adena, restart the server, check the WH and i have 2 adena (It doesn't save the las deposit), BUT, if i extract the 2 adena and deposite 4 adena, restart the server i have 4 adema, is like it can't plus items once they are on the WH but if you take them out and put them back again (no matter the amount) it works ok ... any idea?

Thanks again Guys!!

[MELERIX]

he is trying to say, that your tables should use innoDB engine, if not... then you should change them using that SQL query.

but well, if you are already using MySQL 5.5.x innoDB engine is by default for all tables.

[knoppix]

Thanks! - Working properly on my Test Server, i will apply it to the live server tomorrow.

Let you know if anything goes wrong again .

Thanks a lot again.

[jamaica]

and for a server like 4 gb ddr2 dual core intel 3.00 Ghz hdd 320 gb IDE video card 1 gb what kind of settins should i make on this


java -Djava.util.logging.manager=com.l2jserver.util.L2LogManager -Xms1024m -Xmx4096m -cp ./../libs/*:l2jserver.jar com.l2jserver.gameserver.GameServer > log/stdout.log 2>&1

[sherlockholmes]

may give me a hand with centos mysql settings as it is different from debian .. operating system when you put the configuration that is here the only thing it does is give me errors of any kind and making me not .. My current setup is this

Code: Select all

  # This was formally known as [safe_mysqld]. Both versions are currently parsed.[mysqld_safe]socket          = /var/run/mysqld/mysqld.socknice            = 0open-files-limit = 8192 [mysqld]    set-variable=local-infile=0    datadir=/var/lib/mysql    socket=/var/lib/mysql/mysql.sock    user=mysql    # Default to using old password format for compatibility with mysql 3.x    # clients (those using the mysqlclient10 compatibility package).    old_passwords=1     skip-external-locking## Instead of skip-networking the default is now to listen only on# localhost which is more compatible and is not less secure.bind-address            = 0 # The default storage   engine that will be used when create new tables whendefault-storage-engine=InnoDB # Set the SQL mode to strictsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"  max_connections = 800table_cache = 2048query_cache_size = 0query_cache_type = 0tmp_table_size = 64Mmax_heap_table_size = 64Mmemlockthread_concurrency = 8thread_cache_size = 200max_allowed_packet = 16Mread_buffer_size = 128Kread_rnd_buffer_size = 16Mjoin_buffer_size = 2Msort_buffer_size = 2Mlow-priority-updatestransaction_isolation = READ-COMMITTED  #*** MyISAM Specific options[myisamchk]max_sort_file_size = 100Gkey_buffer=64Msort_buffer=64Mread_buffer=384M# *** INNODB Specific options ***innodb_additional_mem_pool_size = 16Minnodb_buffer_pool_size = 1Ginnodb_data_file_path = ibdata1:10M:autoextendinnodb_thread_concurrency = 8innodb_flush_log_at_trx_commit = 2innodb_log_buffer_size = 16Minnodb_log_file_size = 256Minnodb_log_files_in_group = 2innodb_max_dirty_pages_pct = 90innodb_flush_method = O_DIRECTinnodb_lock_wait_timeout = 120innodb_file_per_table = 1innodb_support_xa = 0innodb_checksums = 0innodb_doublewrite = 0innodb_open_files = 2400skip-federated [mysqldump]quickmax_allowed_packet = 16M [mysql]no-auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates [mysqlhotcopy]interactive-timeout  

I could not find the path of this file is really necessary? configuration is affected? use centos 5.6

## * IMPORTANT: Additional settings that can override those from this file!# The files must end with '.cnf', otherwise they'll be ignored.#!includedir /etc/mysql/conf.d/