I want to bring a best performance for my Minecraft server and I have 16GB of ram, two 10MB databases and one 16GB database. All 3 of them are highly active databases and I want to configure my server in a best way in order, to provide a highest performance.
Here, I've found some configuration for the my.cnf, but I would love to read your comments and other suggestions on how to bring the best result to my users.
Code: Select all
# Place this content under [mysqld] in the my.cnf
skip-external-locking
sysdate-is-now
default-storage-engine = InnoDB
innodb_file_per_table = 1
innodb_file_format = barracuda
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 10M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_fast_shutdown = 0
transaction_isolation = READ-COMMITTED
max_connections = 100
connect_timeout = 86400
wait_timeout = 86400
interactive_timeout = 86400
max_allowed_packet = 64M
open_files_limit = 2048
table_cache = 2048
net_buffer_length = 8K
query_cache_type = 1
query_cache_size = 16M
thread_cache = 100
thread_stack = 512K
tmp_table_size = 64M
key_buffer_size = 64M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid