content_image/666659.jpg content_image/666663.jpg content_image/666667.jpg
<img src='content_image/666659.jpg'>

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 

<img src='content_image/666663.jpg'>

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 

<img src='content_image/666667.jpg'>

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 

