Optimal size of innodb_log_file_size

As you know, during commit InnoDB writes the data at once into data files and records changes in the first innodb_log_file. The fact that write data directly to the table – a much more expensive operation than to record changes in the binary log. Keeping innodb_log_file allows optimization of I/O: write data to successive...

Scroll to top