hard20 pts · first answer countsmysqltransactions
Faster commits with a durability cost
A team sets innodb_flush_log_at_trx_commit = 2 to speed up writes. What is the real risk?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- Why InnoDB over MyISAMDatabase Administrator
- Finding slow MySQL queriesDatabase Administrator
- Non-repeatable readDatabase Administrator
- MySQL default isolation levelDatabase Administrator
- Restoring a Percona XtraBackupDatabase Administrator