########################################################################### ## MaNGOS Optimizations by alexluana @ cmangos.net ## ## and Wizardry and Steamworks ## ########################################################################### #################################### General sort_buffer_size = 4M join_buffer_size = 4M ################## Choose #max_allowed_packet = 1M # Default #max_allowed_packet = 32M # 256 MB RAM max_allowed_packet = 64M # 1 GB RAM #max_allowed_packet = 128M # 2.5+ GB RAM ################## table_cache = 4096 binlog_cache_size = 1M max_heap_table_size = 64M sort_buffer_size = 8M join_buffer_size = 8M thread_cache_size = 24 thread_concurrency = 16 query_cache_limit = 32M query_cache_size = 128M ft_min_word_len = 4 thread_stack = 32M tmp_table_size = 128M key_buffer_size = 128M read_buffer_size = 2M read_rnd_buffer_size = 16M bulk_insert_buffer_size = 32M myisam_sort_buffer_size = 64M #################################### MyISAM [myisamchk] key_buffer_size = 64M sort_buffer_size = 64M read_buffer = 8M write_buffer = 8M #################################### InnoDB # Values between 20M and 50M are enough for character tables and for every innodb database. innodb_additional_mem_pool_size = 32M # 1 To Processors of 1 or 2 cores. # 2 for Quad CoRe. # 4 for i7 / Xeon and 8 for Bi-XEON (2 processors). innodb_thread_concurrency = 1 # Depends on the hardware, can be O_DSYNC or O_DIRECT. innodb_flush_method = O_DSYNC # 0 to reduce the I/O of HDD, but in case of a failure data from the last transaction may be lost. # 1 is recommended for losing nothing. # (More I/O) 2 Mix between one and two. innodb_flush_log_at_trx_commit = 1 # The size of the table of characters plus a margin. # ¡¡¡¡CAREFUL THIS IS RESERVED BY MYSQL!!!! innodb_buffer_pool_size = 256M # Recommended for reduce log file access. innodb_log_files_in_group = 2 # Size of the log. # innodb_log_file_size x innodb_log_files_in_group. innodb_log_file_size = 16M # Buffer needed to process... # 1/4 del log_size total. innodb_log_buffer_size = 8M # Recommended to reduce file access. innodb_file_per_table = 1 # Disable table lock. We do not care that an application crash or MaNGOS crashes too!. innodb_table_locks = 0