content_image/768805.jpg content_image/768806.jpg content_image/768811.jpg content_image/768810.jpg
• innodb_flush_method 

Only consider enabling innodb_dedicated_server  if the MySQL instance resides on a dedicated server where it can use all available system resources. For example, consider enabling if you run MySQL Server in a Docker container or dedicated VM that only runs MySQL. Enabling innodb_dedicated_server  is not recommended if the MySQL instance shares system resources with other applications. 

The information that follows describes how each variable is automatically configured. 

• innodb_buffer_pool_size 

Buffer pool size is configured according to the amount of memory detected on the server. 

<img src='content_image/768805.jpg'>

• innodb_log_file_size 

As of MySQL 8.0.14, log file size is configured according to the automatically configured buffer pool size. 

<img src='content_image/768806.jpg'>

<img src='content_image/768811.jpg'>

## Note 

Prior to MySQL 8.0.14, the innodb_log_file_size  variable was automatically configured according to the amount of memory detected on the server, as shown below: 

<img src='content_image/768810.jpg'>

• innodb_log_files_in_group 

The number of log files is configured according to the automatically configured buffer pool size (in gigabytes). Automatic configuration of the innodb_log_files_in_group  variable was added in MySQL 8.0.14. 

