SQL Settings? need help

zEro

New Member
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:

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?
 
Back
Top