Is it a error in doc?
Document Section: 15.8.12 Enabling Automatic Configuration for a Dedicated MySQL Server
Contents from doc:
-------------------------------------------------------------------------------
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.
Table 15.11 Automatically Configured Number of Log Files
Buffer Pool Size Number of Log Files
Less than 8GB ROUND(buffer pool size)
8GB to 128GB ROUND(buffer pool size * 0.75)
Greater than 128GB 64
-------------------------------------------------------------------------------
When buffer pool size between 8G and 128G,logfiles#=round(buffer pool size * 0.75);Suppose the buffer pool is 100G, then logfile#=round(100*0.75) = 75, the value greater than the next rank buffer pool size(64).
So, is it a wrong formula or something else?
Subject
Views
Written By
Posted
Is it a error in doc?
319
July 06, 2022 08:33AM
192
July 06, 2022 08:59AM
181
July 06, 2022 09:40AM
172
July 06, 2022 09:58AM
169
July 11, 2022 05:58AM
171
July 13, 2022 12:52AM
144
October 06, 2022 10:00AM
55
December 07, 2022 06:14AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.