MySQL Forums
Forum List  »  Docs

Re: Is it a error in doc?
Posted by: king Wu
Date: December 07, 2022 06:14AM

I really don't think this is an error, not even a question you should ask if you read carefully.
First of all, you should know what section you are read. It's "15.8.12 Enabling Automatic Configuration for a Dedicated MySQL Server". Once you figure out that, you'll know it's not a standalone system variable in this case (use system variable "innodb_dedicated_server" to configure other variables automatically).Variable "innodb_log_file_size" and "innodb_log_files_in_group" are a pair of variables, which equals to "innodb_redo_log_capacity".
So in your example, when buffer pool size is between 8G and 128G, the "innodb_log_file_size" should be 1GiB, meanwhile "innodb_log_files_in_group" should be [6,96]. innodb_redo_log_capacity = innodb_log_file_size * innodb_log_files_in_group = [6GiB,96GiB].
When buffer pool size is greater than 128GB, "innodb_log_file_size" should be 2GiB, meanwhile "innodb_log_files_in_group" should be 64.innodb_redo_log_capacity = innodb_log_file_size * innodb_log_files_in_group = 128GiB.
Now it's clear! Why you think 96GiB is larger than 128GiB ?

Dee Wu
yabulidige@163.com

Options: ReplyQuote


Subject
Views
Written By
Posted
480
July 06, 2022 08:33AM
294
July 06, 2022 08:59AM
292
July 06, 2022 09:40AM
263
July 06, 2022 09:58AM
263
July 11, 2022 05:58AM
279
July 13, 2022 12:52AM
245
October 06, 2022 10:00AM
Re: Is it a error in doc?
144
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.