MySQL tunning (innodb_io_capacity) based on IOPS

March 6, 2014 9.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?
3 Answers

you can install fio to test the read/write speed

How much did you end up using?

Have another answer? Share your knowledge.