Dayz Epoch Server on VM

[Anthony]

I see. No, I am not running the game off an SSD. Maybe this is something I will give a shot in the near future. Thank you.

[StallionFire]

yea, we use a 10gb ssd for database and hard drive swap file. 5gb for swap file and then 5gb for MySQL database. The rest of the game files run on the regular hard drive.



I just think in my case that we need more CPU Turbo power and with the VM we don't get all the turbo or at least it's not turbo on all threads. so depending on the threads being used and the hypervisor, this will cause a slight reduction in performance vs a dedicated server which is what I am thinking about moving to next.

[Anthony]

I was able to resolve the issue by tweaking MySQL settings.

[pcgamer]

I was able to resolve the issue by tweaking MySQL settings.

What settings?

[Anthony]

C:\ProgramData\MySQL\MySQL Server 5.6\my.ini
Leading # is the default value on my MySQL install.

#innodb_flush_log_at_trx_commit=1
innodb_flush_log_at_trx_commit=2

#innodb_buffer_pool_size=8M
innodb_buffer_pool_size=1024M

#innodb_log_buffer_size=1M
innodb_log_buffer_size=4M

#innodb_log_file_size=48M
innodb_log_file_size=256M

I saw a dramatic decrease in the amount of disk I/O from the SQL DB so there is no need to put the DB on an SSD. Users have reported improved performance since making the changes, but there is still room for improvement, which I am still working on.