Server Parameters: innodb_buffer_pool_size, query_cache_limit, etc
Possible to include these in server parameters?
The following server parameters are now configurable:
Please refer to the following how to articles for how to configure the values from the Azure portal (https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters) or CLI (https://docs.microsoft.com/en-us/azure/mysql/howto-configure-server-parameters-using-cli).
The innodb_buffer_pool_size parameter is tied to the SKU. Please refer to the following document for the values: https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#non-configurable-server-parameters
Andrea Lam on behalf of the Azure DB for MySQL team
Beleznay, David (Relic) commented
Is there any plans to add key_buffer_size as a configurable value ? if not, is there a way to tune it as a percentage of something else ?
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.