question about encoding of auto-commit events in the binlog

[Mark Callaghan]

I thought I read a CL for a bug fix that stated that auto-commit events
would be encoded differently as of a new MySQL 5.0 release. The new encoding
is to always wrap the SQL statement with binlog events for BEGIN and COMMIT.
Is that the case, and if so, in which release does this change occur?

--
Mark Callaghan
mcallaghan@...

[Mark Callaghan]

Found it. Bug 26395 described at
http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-56.html


On Wed, May 7, 2008 at 2:39 PM, Mark Callaghan <mcallaghan@...>
wrote:

> I thought I read a CL for a bug fix that stated that auto-commit events
> would be encoded differently as of a new MySQL 5.0 release. The new encoding
> is to always wrap the SQL statement with binlog events for BEGIN and COMMIT.
> Is that the case, and if so, in which release does this change occur?
>
> --
> Mark Callaghan
> mcallaghan@...




--
Mark Callaghan
mcallaghan@...

[Eric Bergen-4]

Hi Mark,

Are you referring to the fix for http://bugs.mysql.com/bug.php?id=29288

-Eric


On Wed, May 7, 2008 at 2:39 PM, Mark Callaghan <mcallaghan@...> wrote:
> I thought I read a CL for a bug fix that stated that auto-commit events
>  would be encoded differently as of a new MySQL 5.0 release. The new encoding
>  is to always wrap the SQL statement with binlog events for BEGIN and COMMIT.
>  Is that the case, and if so, in which release does this change occur?
>
>  --
>  Mark Callaghan
>  mcallaghan@...
>



--
high performance mysql consulting.
http://provenscaling.com

--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe:    http://lists.mysql.com/replication?unsub=lists@...

[Mark Callaghan]

That is related, but http://bugs.mysql.com/bug.php?id=26395 has the change
to always use BEGIN/COMMIT events in the binlog.

On Wed, May 7, 2008 at 7:45 PM, Eric Bergen <eric@...> wrote:

> Hi Mark,
>
> Are you referring to the fix for http://bugs.mysql.com/bug.php?id=29288
>
> -Eric
>
>
> On Wed, May 7, 2008 at 2:39 PM, Mark Callaghan <mcallaghan@...>
> wrote:
> > I thought I read a CL for a bug fix that stated that auto-commit events
> >  would be encoded differently as of a new MySQL 5.0 release. The new
> encoding
> >  is to always wrap the SQL statement with binlog events for BEGIN and
> COMMIT.
> >  Is that the case, and if so, in which release does this change occur?
> >
> >  --
> >  Mark Callaghan
> >  mcallaghan@...
> >
>
>
>
> --
> high performance mysql consulting.
> http://provenscaling.com
>

--
Mark Callaghan
mcallaghan@...