maria-developers team mailing list archive

Thread
Date

New (by Psergey): Make mysqlbinlog not to output unneeded COMMIT statements (38)

To: monty@xxxxxxxxxxxx
From: worklog-noreply@xxxxxxxxxxxx
Date: Sat, 8 Aug 2009 12:40:44 +0300 (EEST)
Delivered-to: worklog-db@xxxxxxxxxxxx

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Make mysqlbinlog not to output unneeded COMMIT statements
CREATION DATE..: Sat, 08 Aug 2009, 12:40
SUPERVISOR.....: Monty
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 38 (http://askmonty.org/worklog/?tid=38)
VERSION........: Benchmarks-3.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

This comes from MySQL BUG#23890: 

  mysqlbinlog --database=bar N-bin.000003 

will output all the COMMIT statements in the binary log even if it didn't print
any statements between the COMMITs (because all the statements that were there
were for the other databases).

The fix is trivial: in mysqlbinlog, check if we've printed anything after we've
printed the previous commit statement.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v3.5.9)