On Sat, Mar 14, 2009 at 4:33 PM, Cui Shijun <rancpine@stripped> wrote:
> What will happen if the disk is full when mysql flush binlog to it?
> If I use innodb engine(mysql-5.1.22) and turn on the binlog, is
> there any chance
> that mysql has data updated without binlog flushed?
> Will mysql return with fail when it fail on binlog?
From the docs.
"Even with sync_binlog set to 1, there is still the chance of an
inconsistency between the table content and binary log content in case
of a crash."
"To resolve this, you should set --innodb_support_xa to 1. Although
this option is related to the support of XA transactions in InnoDB, it
also ensures that the binary log and InnoDB data files are
"Having innodb_support_xa enabled on a replication master — or on any
MySQL server where binary logging is in use — ensures that the binary
log does not get out of sync compared to the table data. "
This is covered here
> Thank you.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1