MySQL tunning (innodb_io_capacity) based on IOPS
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?