List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:May 19 2009 10:01pm
Subject:Re: Feedback needed for WL#2687
View as plain text  
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
Thread
Feedback needed for WL#2687Alfranio Correia13 May
  • Re: Feedback needed for WL#2687Mats Kindahl13 May
    • Re: Feedback needed for WL#2687Alfranio Correia13 May
  • Re: Feedback needed for WL#2687He Zhenxing14 May
    • Re: Feedback needed for WL#2687He Zhenxing14 May
    • Re: Feedback needed for WL#2687Alfranio Correia15 May
      • Re: Feedback needed for WL#2687He Zhenxing18 May
  • re: Feedback needed for WL#2687Michael Widenius14 May