Showing entries 1 to 1
Displaying posts with tag: Percona Live Frankfurt (reset)
Oct
30
2018
On the consequences of sync_binlog != 1 (part #1)
Posted by Jean-François Gagné on Tue 30 Oct 2018 06:00 UTC
Tags:

A well-known performance booster in MySQL is to set sync_binlog to 0.  However, this configuration alone comes with serious consequences on consistency and on durability (the C and D of ACID); I explore those in this series.  In this post, I give some background on the sync_binlog parameter and I explain part of the problem with setting it to 0 (or to a value different from 1).  The other

Showing entries 1 to 1