Server Parameters: innodb_buffer_pool_size, query_cache_limit, etc
Possible to include these in server parameters?
innodb_buffer_pool_size
query_cache_limit
query_cache_type
query_cache_size
join_buffer_size
Thank you.
Ian
Ian
shared this idea
4 comments
-
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.
