InnoDB System Variables System Variable innodb_log_files_in_group Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value 2 Minimum Value 2 Maximum Value 100 The number of log files in the log group.  InnoDB  writes to the files in a circular fashion. The default (and recommended) value is 2. The location of the files is specified by  innodb_log_group_home_dir . The combined size of log files ( innodb_log_file_size  *  innodb_log_files_in_group ) can be up to 512GB. For related information, see Redo Log File Configuration. • innodb_log_group_home_dir Command-Line Format --innodb-log-group-home-dir=dir_name System Variable innodb_log_group_home_dir Scope Global Dynamic No SET_VAR  Hint Applies No Type Directory name The directory path to the  InnoDB  redo log files, whose number is specified by innodb_log_files_in_group . If you do not specify any  InnoDB  log variables, the default is to create two files named  ib_logfile0  and  ib_logfile1  in the MySQL data directory. Log file size is given by the  innodb_log_file_size  system variable. For related information, see Redo Log File Configuration. • innodb_log_spin_cpu_abs_lwm Command-Line Format --innodb-log-spin-cpu-abs-lwm=# System Variable innodb_log_spin_cpu_abs_lwm Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 80 Minimum Value 0 Maximum Value 4294967295 Defines the minimum amount of CPU usage below which user threads no longer spin while waiting for flushed redo. The value is expressed as a sum of CPU core usage. For example, The default value of 80 3260