From: Michael Widenius
Date: May 19 2009 10:01pm
Subject: Re: Feedback needed for WL#2687
List-Archive: http://lists.mysql.com/internals/36766
Message-Id: <18963.11332.976722.10826@narttu.askmonty.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi!

>>>>> "Alfranio" == Alfranio Correia <Alfranio.Correia@stripped> writes:

<cut>

Alfranio> SOLUTION
Alfranio> --------
Alfranio> To correctly handle the mix of transactional and non-transactional
Alfranio> tables, we
Alfranio> proceed as follows.

Alfranio> In STMT mode, statements are logged to the binary log upon committing or
Alfranio> rolling back a transaction thus preserving any semantic among the
Alfranio> statements.

To clarify the above, when will the following inserts be logged:

CREATE TABLE test (a int) engine=myisam;
BEGIN;
INSERT INTO test values(1);
INSERT INTO test values(2);
COMMIT;

Will the be logged at once or at commit ?
If they are logged at commit, this will not be safe in an multi user
environment.

Regards,
Monty