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
