innodb_flush_log_at_trx_commit

This page is original PmaControl documentation. It keeps a practical index structure for MySQL optimization work, without copying third-party content or depending on an external product.

Role

Controls commit durability and redo-log flush frequency.

Diagnosis

SHOW VARIABLES LIKE 'innodb_flush_log_at_trx_commit';
SHOW GLOBAL STATUS LIKE '%innodb%';

The status counters do not always use the same name as the variable. Use this command as a starting point, then complete with performance_schema, SHOW ENGINE INNODB STATUS, or system metrics.

Tuning

Value 1 maximizes durability. Values 0 or 2 reduce I/O at the cost of a loss window.

Risks

• A global value that is too high can increase memory consumed at startup.
• A per-connection value can explode with max_connections.
• A change must be tested with a before/after measurement and rollback.