Been having issues with my DB from what I can tell, just after restarts and at random times between restarts the lock/unlock functions and trader menus become extremely slow, and vehicles don't spawn when buying them. If players relog it sometimes fixes it, but im thinking this is a database issues. I currently have 3 added databases on the mysql server, one for Altis Life for A3 which is constantly running with one server, and shared with another server when I bring it up for testing. I then have 2 epoch databases, one running all the time for my main server and one for a test server when I bring it up. Wondering if it could be something Im missing with the config?
Current CFG is
[mysqld]
pid_file = "mysql.pid"
key_buffer = 16M
max_allowed_packet = 2M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 128M
log_error = "mysql_error.log"
table_cache = 64
thread_cache = 16
query_cache_size = 64M
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 32M
innodb_log_file_size = 256M
innodb_log_buffer_size = 10M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
I can provide anymore information and would really appreciate some help/advice with this.
Question
Lukedbx
Been having issues with my DB from what I can tell, just after restarts and at random times between restarts the lock/unlock functions and trader menus become extremely slow, and vehicles don't spawn when buying them. If players relog it sometimes fixes it, but im thinking this is a database issues. I currently have 3 added databases on the mysql server, one for Altis Life for A3 which is constantly running with one server, and shared with another server when I bring it up for testing. I then have 2 epoch databases, one running all the time for my main server and one for a test server when I bring it up. Wondering if it could be something Im missing with the config?
Current CFG is
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now