List:General Discussion« Previous MessageNext Message »
From:ewen fortune Date:March 16 2009 12:20pm
Subject:Re: what will happen if the disk is full when mysql flush binlog to
it
View as plain text  
Hi Cui,

On Sat, Mar 14, 2009 at 4:33 PM, Cui Shijun <rancpine@stripped> 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=1
>
>
Thread
what will happen if the disk is full when mysql flush binlog to itCui Shijun14 Mar
  • Re: what will happen if the disk is full when mysql flush binlog to itewen fortune16 Mar