MDEV-20907 Set innodb_log_files_in_group=1 by default

Historically, InnoDB split the redo log into at least 2 files.
MDEV-12061 allowed the minimum to be innodb_log_files_in_group=1,
but it kept the default at innodb_log_files_in_group=2.

Because performance seems to be slightly better with only one log file,
and because implementing an append-only variant of the log would require
a single file, let us define the default to be 1, and have
innodb_log_file_size=96M, to retain the same default total size.

1 files changed, 3 insertions, 3 deletions

diff --git a/win/packaging/ca/CustomAction.cpp b/win/packaging/ca/CustomAction.cpp
index bc3fcfea94f..8a67bcbd9de 100644
--- a/win/packaging/ca/CustomAction.cpp
+++ b/win/packaging/ca/CustomAction.cpp
@@ -717,12 +717,12 @@ LExit:
 /* 
   Sets Innodb buffer pool size (1/8 of RAM by default), if not already specified
   via command line.
-  Calculates innodb log file size as min(50, innodb buffer pool size/8)
+  Calculates innodb log file size as min(100, innodb buffer pool size/4)
 */
 extern "C" UINT __stdcall PresetDatabaseProperties(MSIHANDLE hInstall)
 {
   unsigned long long InnodbBufferPoolSize= 256;
-  unsigned long long InnodbLogFileSize= 50;
+  unsigned long long InnodbLogFileSize= 100;
   wchar_t buff[MAX_PATH];
   UINT er = ERROR_SUCCESS;
   HRESULT hr= S_OK;
@@ -765,7 +765,7 @@ extern "C" UINT __stdcall PresetDatabaseProperties(MSIHANDLE hInstall)
     swprintf_s(buff, L"%llu",InnodbBufferPoolSize);
     MsiSetPropertyW(hInstall, L"BUFFERPOOLSIZE", buff);
   }
-  InnodbLogFileSize = min(50, InnodbBufferPoolSize);
+  InnodbLogFileSize = min(100, 2 * InnodbBufferPoolSize);
   swprintf_s(buff, L"%llu",InnodbLogFileSize);
   MsiSetPropertyW(hInstall, L"LOGFILESIZE", buff);