When monitoring i/o it on server it indicating me that mysql is the cause. And it really saves at some points even 50Mb/s. (iotop -a) THere is mysql db large around 10Gb, i think some tables must be saved on disk or something causing this high data writing (not reading). Here im pasting mysql values and report of mysqltuner tools: http://pastebin.com/nLhvWg04 Please can anyone advice me commands to run or what action to do to eliminate data mysql writing? Thank you
Hard to say. Averaging 39 connections per minute isn't crazy but the database size is rather large. Do you know if the database is exceeding your available RAM and hitting SWAP. 21% writes seems really high. What sort of usage is this for? It wouldn't be considered a write unless an INSERT or UPDATE statement was performed. Do you use the database for session management or some other record that every user would trigger? I would also look at switching to INNODB on a database this size with the available RAM you have if at all possible. MyISAM is virtually untunable, whereas INNODB will give you a ton of tuning options which can drastically change the performance of the database.