Server Parameters: innodb_buffer_pool_size, query_cache_limit, etc
Possible to include these in server parameters?
innodbbufferpoolsize
querycachelimit
querycachetype
querycachesize
joinbuffer_size
Thank you.
Ian
Ian
shared this idea
The following server parameters are now configurable:
- query_cache_limit
- query_cache_type
- query_cache_size
- join_buffer_size
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
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL team
5 comments
-
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
Per https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html:
"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.