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?
520
July 06, 2022 08:33AM
343
July 06, 2022 08:59AM
317
July 06, 2022 09:40AM
312
July 06, 2022 09:58AM
286
July 11, 2022 05:58AM
302
July 13, 2022 12:52AM
266
October 06, 2022 10:00AM
168
December 07, 2022 06:14AM


Sorry, you can't reply to this topic. It has been closed.

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.