Jump to content
  • 0

Database Issues?


Lukedbx

Question

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.
Cheers, Luke.
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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Discord

×
×
  • Create New...