mysql my.ini settings / mysql rollback

[kat]

I'm suffering from database rollbacks with 20-25+ players. 

Is there any obvious reason why its doing this from looking at my sql settings?

 

With a dedicated server are you renting a mysql server or are you hosting it yourself alongside an epoch server?

 

Here is my, my.ini:

 

 

[mysqld]

port= 3306

socket = "C:/xampp/mysql/mysql.sock"

basedir = "C:/xampp/mysql" 

tmpdir = "C:/xampp/tmp" 

datadir = "C:/xampp/mysql/data"

pid_file = "mysql.pid"

key_buffer = 16M

max_allowed_packet = 4M

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 234M

log_error = "mysql_error.log"

plugin_dir = "C:/xampp/mysql/lib/plugin/" 

server-id = 1

innodb_data_home_dir = "C:/xampp/mysql/data"

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = "C:/xampp/mysql/data"

innodb_buffer_pool_size = 1G

innodb_additional_mem_pool_size = 256M

innodb_log_file_size = 128M

innodb_log_buffer_size = 10M

innodb_flush_log_at_trx_commit = 2

innodb_lock_wait_timeout = 50

 

[mysqldump]

quick

max_allowed_packet = 16M

 

[mysql]

no-auto-rehash

 

[isamchk]

key_buffer = 8M

sort_buffer_size = 8M

read_buffer = 2M

write_buffer = 2M

 

[myisamchk]

key_buffer = 20M

sort_buffer_size = 20M

read_buffer = 2M

write_buffer = 2M

 

[mysqlhotcopy]

interactive-timeout

 

 

Any feedback would be amazing!

[MGT]

With a dedi you can have as many instances of MySQL on your server

[cen]

you should never have to restart your SQL server.