MySQL Forums
Forum List  »  InnoDB

Redo buffer flushing in MySQL
Posted by: Josh Visser
Date: September 18, 2021 06:20AM

Hi,

I was wondering if anyone could please explain how the following parameters relate to each other:

> innodb_flush_log_at_trx_commit

> innodb_flush_log_at_timeout

The MySQL docs state that if innodb_flush_log_at_trx_commit is set to 0 or 2, flushing happens every 1 seconds. The default value for the innodb_flush_log_at_timeout parameter is 1 seconds. Does that mean if I increase the value of the innodb_flush_log_at_timeout parameter to 2700, that flushing of the redo logs will only happen every 2700 seconds when the value for the innodb_flush_log_at_trx_commit is set to 0 or 2? I tried to test it, but when checking the results of the SHOW ENGINE INNODB STATUS command, flushing still happens every 1 second even if the value for the innodb_flush_log_at_timeout is increased.

Options: ReplyQuote


Subject
Views
Written By
Posted
Redo buffer flushing in MySQL
99
September 18, 2021 06:20AM


Sorry, only registered users may post in this forum.

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.