Hi Cui, On Sat, Mar 14, 2009 at 4:33 PM, Cui Shijun <[email protected]> wrote: > hi, > 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 synchronized. " "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 http://dev.mysql.com/doc/refman/5.1/en/full-disk.html and here http://dev.mysql.com/doc/refman/5.1/en/binary-log.html Cheers, Ewen > > Thank you. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[email protected] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
