Enabling Automatic Configuration for a Dedicated MySQL Server 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. Buffer pool size is configured according to the amount of memory detected on the server. As of MySQL 8.0.14, log file size is configured according to the automatically configured buffer pool size. 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: 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. • innodb_flush_method • innodb_buffer_pool_size • innodb_log_file_size • innodb_log_files_in_group Table 15.8 Automatically Configured Buffer Pool Size Detected Server Memory Buffer Pool Size Less than 1GB 128MiB (the default value) 1GB to 4GB detected server memory  * 0.5 Greater than 4GB detected server memory  * 0.75 Buffer Pool Size Log File Size Less than 8GB 512MiB 8GB to 128GB 1024MiB Greater than 128GB 2048MiB Table 15.9 Automatically Configured Log File Size Table 15.10 Automatically Configured Log File Size (MySQL 8.0.13 and Earlier) Note Detected Server Memory Log File Size < 1GB 48MiB (the default value) <= 4GB 128MiB <= 8GB 512MiB <= 16GB 1024MiB > 16GB 2048MiB 3145