Database on SSD? - will it make it faster? - (Dayz epoch)

[MikeGracia]

Hi all,

Just wondering if having the DayZ Epoch MySQL database on an SSD will help avoid lag? OR will it being on a separate disk to the game files make it worse?

Any thoughts?

[soja]

It will not hurt performance at all(if its on the same machine as the game server). I am not familiar with how dayz utilizes mysql databases, but in general putting mysql on a SSD will improve performance, due to SSD's being far superior in random reads/writes compared to a traditional HDD. Whether or not it will be a noticeable improvement depends on how it is used, but I have seen many dayz server owners who have mysql on a SSD on these forums.

[Edge100x]

I'd definitely recommend putting the MySQL database on local SSD-based storage if it is available. If you purchase a VDS, secondary SSD storage is an option on the order page. It also works well for backups of critical files, since it is kept by default across VDS reinstalls.

[MikeGracia]

Okay cool - thanks for the advice. One more question...

How about running the whole arma install on the SSD... Would this be possible?

I already have a server with nfo (3 core VDS), but am thinking of upgrading to a 4 core, with SSD for either just the database, OR database and arma install.

[soja]

After doing some research, much to my suprise, I found that client-side you can see a significant performance boost(I don't play dayz).

Watch windows resource monitor on your vds and see if the game server consistently streams data from disk. It was claimed that this is what the client does, and there isn't much, if any caching done by the game. If this is the case for the server as well then you could see a performance benefit.

There is no reason you couldn't run the whole server from SSD

From what I have read on the forums here, you need about 2 vds cores for an arma server, so you might want to stick with 3 core for arma+mysql if you don't have any expansion plans(more servers).

[.=QUACK=.Major.Pain]

Most dayz mods only use default of 2 cpu cores.
Some command lines have -cpuCount=2 or they don't declare it in which it will then default to 2.

Origins is the only mod that I have come across that calls for 6.
-cpuCount=6
But it is a more intense mod with a lot of addons and at times still sees minimal desync.

I host most of my databases on a seperate city/server/compnay on my webhosting account. It's a VDS just for websites and dayz databases. Easy to upgrade anytime I need to.