Ability to modify innodb_io_capacity and innodb_io_capacity_max on CloudSQL for MySQL

[Derek Downey]

I would like to be able to modify my innodb_io_capacity and innodb_io_capacity_max settings, but these settings are not available as options on the documentation: https://cloud.google.com/sql/docs/mysql/flags#mysql-i

mysql> show variables like '%innodb_io_capacity%';

+------------------------+-------+

| Variable_name | Value |

+------------------------+-------+

| innodb_io_capacity | 5000 |

| innodb_io_capacity_max | 10000 |

+------------------------+-------+

2 rows in set (0.00 sec)

Is there any reason we can't modify these? An example of when it would be useful for efficiency reasons is described in this excellent blog post: https://www.percona.com/blog/2020/01/22/innodb-flushing-in-action-for-percona-server-for-mysql/

[noverlyjoseph]

Here's an explanation of why it is not available at the moment.

https://stackoverflow.com/a/56632754/8191648