Question

MySQL tunning (innodb_io_capacity) based on IOPS

Posted March 6, 2014 9.5k 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.

3 answers

you can install fio to test the read/write speed

How much did you end up using?

Submit an Answer