In my case it's for analytics, so I am ok with some data loss in case of a failu... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		XCSme 24 days ago \| parent \| context \| favorite \| on: MySQL foreign key cascade operations finally hit t... 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 24 days ago [–]

The 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-...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact