3 ms·
In my case it's for analytics, so I am ok with some data loss in case of a failure. How do I set the fsync stuff? Does if have to be turned off?
by XCSme 8mo ago
In my case it's for analytics, so I am ok with some data loss in case of a failure.
How do I set the fsync stuff? Does if have to be turned off?
- evanelias 8mo agoThe sync_binlog server variable controls this behavior. The default of 1 means to fsync every time, which is best for durability but worst for performance. See https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html#sysvar_sync_binlog https://dev.mysql.com/doc/refman/8.4/en/replication-options-...