Hi Cui,
On Sat, Mar 14, 2009 at 4:33 PM, Cui Shijun 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/mysql?unsub=ewen.fort...@gmail.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
