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
622
July 06, 2022 08:33AM
Re: Is it a error in doc?
432
July 06, 2022 08:59AM
395
July 06, 2022 09:40AM
379
July 06, 2022 09:58AM
346
July 11, 2022 05:58AM
378
July 13, 2022 12:52AM
339
October 06, 2022 10:00AM
232
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.