I got trouble lately with the command "max_prepared_stmt_count" that keeps saying "create more than max_prepared_stmt_count statements (current value: 16382)) in"
my sql settings are:
by the way, after 3 hrs some players positions won't be saved anymore, i guess thats the command above forcing it maybe?
anyone got better settings for 3x 60 Slots DayZ Server?
my sql settings are:
pid_file = "mysql.pid"
key_buffer = 2G
table_cache = 64
sort_buffer_size = 8M
read_buffer_size = 256K
read_rnd_buffer_size = 512K
net_buffer_length = 8K
max_allowed_packet = 4M
myisam_sort_buffer_size = 8M
skip-external-locking
skip-federated
max_connections = 10000
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 512M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
by the way, after 3 hrs some players positions won't be saved anymore, i guess thats the command above forcing it maybe?
anyone got better settings for 3x 60 Slots DayZ Server?