My Oracle Support Banner

MySQL Server Variable: innodb_flush_log_at_trx_commit; innodb_flush_log_at_timeout (Doc ID 2085343.1)

Last updated on MARCH 24, 2020

Applies to:

MySQL Server - Version 5.0 and later
Information in this document applies to any platform.

Purpose

Explain when and why to use the innodb_flush_log_at_trx_commit and innodb_flush_log_at_timeout settings in MySQL Server.

Scope

Detailed general guidance for DBAs who are familiar with the option and looking for help on how to use it.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Fsync Rate
 innodb_flush_log_at_trx_commit
 Recommendation
 Performance Impact
 innodb_flush_log_at_timeout
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.