Suggestions to consider for your instance to improve MySQL IOPS,

SET GLOBAL innodb_io_capacity_max=18000 # from 2000 SET GLOBAL innodb_io_capacity=9000 # from 200 

for testing and to be applied to my.cnf [mysqld] section before next stop/start of services.

Disclaimer: I am the content author of web site mentioned in my profile, Network profile and could provide additional suggestions.

Suggestions to consider for your instance to improve MySQL IOPS,

SET GLOBAL innodb_io_capacity_max=18000 # from 2000 SET GLOBAL innodb_io_capacity=9000 # from 200 

for testing and to be applied to my.cnf [mysqld] section before next stop/start of services.

Disclaimer: I am the content author of web site mentioned in my profile, Network profile and could provide additional suggestions.

Apr 18, 2019 because SET GLOBAL variable_name=value applies to 'new connections', please wait 1 hour minimum to review impact on io wait time. If your processes typically take 3 hours, wait three hours to review impact, please.