MySQL Forums
Forum List  »  Docs

Is it a error in doc?
Posted by: Stephen Zhao
Date: July 06, 2022 08:33AM

Document Section: 15.8.12 Enabling Automatic Configuration for a Dedicated MySQL Server

Contents from doc:

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?

Options: ReplyQuote

Written By
Is it a error in doc?
July 06, 2022 08:33AM
July 06, 2022 08:59AM
July 06, 2022 09:40AM
July 06, 2022 09:58AM
July 11, 2022 05:58AM
July 13, 2022 12:52AM
October 06, 2022 10:00AM

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.