MySQL tunning (innodb_io_capacity) based on IOPS

Posted March 6, 2014 11.1k views
Hello, I'm trying to tune mysql MySQL servers running on DigitalOcean SSD droplets. The innodb_io_capacity variable should match the server IOPS, according to the documentation and several expert articles. The default innodb_io_capacity value is 200, which is recommended for HDD servers. Does DigitalOcean droplets has an average or minimal IOPS? Is it possible to measure it? Has anyone any recommendation regarding the innodb_io_capacity variable?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
3 answers

you can install fio to test the read/write speed

How much did you end up using?