In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable.
MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf).
The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of the system:
innodb_buffer_pool_size:
-
- <1G: 128M(default value if innodb_dedicated_server is OFF)
- <=4G: Detected Physical RAM * 0.5
- >4G: Detected Physical RAM * 0.75
innodb_log_file_size: …
[Read more]