Server Parameters: innodb_buffer_pool_size, query_cache_limit, etc
Possible to include these in server parameters?
Paulo Diniz commented
With regards to innodb_buffer_pool_size is there a way to see what these values will be set to for the different skus?
Mike Brooks commented
"The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0."
To further iterate on Hong's response below, in order to deliver a consistent experience (performance) for different SKUs, we don't expose these parameters. Doing so may compromise the amount of memory available for other resources at the infrastructure-level.
Hong Wang commented
The innodb_buffer_pool_size is the major memory setting for MySQL, it is fixed in different SKU. We will not let user to change it. You can only increase the SKU to get higher memory.
For query_cache related setting, We are planning to expose to user with limited range.