During working on our project we needed to decide should we use "ElasticSearch" or "MySQL" to record the audit/trail logs of the system. Searching speed is not an issue here, we needed to see the disk I/O performance for both platforms. I had no experience of disk i/o monitoring, so after a little research I decided to monitor the writes per second for both ElasticSearch and MySQL via a simple load running script.
Should I consider writes per second for disk i/o performance ? Am I going in to the right direction ? Also, I'm not sure if less no. of writes per second is better or worst ?