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:
-------------------------------------------------------------------------------
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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Is it a error in doc?
234
July 06, 2022 08:33AM
129
July 06, 2022 08:59AM
109
July 06, 2022 09:40AM
107
July 06, 2022 09:58AM
113
July 11, 2022 05:58AM
110
July 13, 2022 12:52AM
76
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.