Friday, February 21, 2020

[google-cloud-sql-discuss] Ability to modify innodb_io_capacity and innodb_io_capacity_max on CloudSQL for MySQL

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/


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/21694939-3fe6-4643-aca5-1fbeea3d6fbc%40googlegroups.com.

No comments:

Post a Comment