Alfranio Correia wrote:
> Hi all,
> Theres is a final patch, at least from my point of view :), available at
> 5) M...: where M is either N T or T N.
> This case is handled as 3 or 4.
The notion that a mixed statement is either NT or TN implies an ordering within
the statement. That is actually not relevant, since the granule of execution is
a statement from the point of the scheduler.
> IMPLEMENTATION DETAILS
> There are two caches: one for transactional changes (trx-cache) and
> another one
> for non-transactional changes (nontrx-cache). The trx-cache is flushed and
> truncated before committing or rolling back a transaction. The
> nontrx-cache is
> flushed and truncated before finishing a statement. For the 5 cases
> above, these caches are used as follows:
> 1) B T...T C/R: all the statements are transactional.
> In STMT, ROW and MIXED modes, statements or changes are copied to the
> and flushed to the binary log upon committing a transaction or just ignored
> upon rolling a transaction back.
> 2) B N...N C/R: all the statements are non-transactional.
> In STMT, the statements are copied to the trx-cache and flushed to the
> log upon committing or rolling back a transaction. In ROW and MIXED mode,
do you mean rows?
> are copied to the nontrx-cache and flushed to the binary log as
> soon as
> each statement is completed.
Senior Software Engineer
Database Technology Group