Skip to content
PERCONA MONITORING AND MANAGEMENT DOCUMENTATION

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

MySQL check binary log sync status

Description

If the binary log synchronization to disk is disabled, the operating system flushes the binary log to disk as it does any other file. If the operating system crashes, or experiences a power failure, committed transactions may not be synchronized with the binary log.

For more information, see the MySQL documentation and Percona blog posts on the topic.

Resolution

Consider changing SET GLOBAL sync_binlog=1.

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.