If the record here means persisting to disk, it depends on the configuration sync_binlog of my.cnf
However, if you don’t want to lose data after the server crashes, sync_binlog still needs to be enabled.
Therefore, in scenarios where data loss cannot be tolerated, operations will be persisted to the binary log first. After all, log writing is sequential, and the impact on performance is still acceptable.
If the record here means persisting to disk, it depends on the configuration
sync_binlog
of my.cnfHowever, if you don’t want to lose data after the server crashes,
sync_binlog
still needs to be enabled.Therefore, in scenarios where data loss cannot be tolerated, operations will be persisted to the binary log first. After all, log writing is sequential, and the impact on performance is still acceptable.