Re: Is it a error in doc?
From source code, I found the formula as below:
-------------------------------------------------------------------------------
if (auto_buf_pool_size_in_gb < 1.0) {
;
} else if (auto_buf_pool_size_in_gb < 8.0) {
srv_n_log_files = static_cast<ulong>(round(auto_buf_pool_size_in_gb));
} else if (auto_buf_pool_size_in_gb <= 128.0) {
srv_n_log_files =
static_cast<ulong>(round(auto_buf_pool_size_in_gb * 0.75));
} else {
srv_n_log_files = 64;
}
-------------------------------------------------------------------------------
The automatic configuration algorithm of innodb_log_files_in_group is so simple and rude, and now, could this be considered a source code bug?
Subject
Views
Written By
Posted
1174
July 06, 2022 08:33AM
Re: Is it a error in doc?
695
July 06, 2022 08:59AM
665
July 06, 2022 09:40AM
746
July 06, 2022 09:58AM
575
July 11, 2022 05:58AM
633
July 13, 2022 12:52AM
586
October 06, 2022 10:00AM
460
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.