Hi!

>>>>> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:

Heikki> Guilhem,
Heikki> this is a known problem and mentioned in the Restrictions section of the
Heikki> InnoDB online manual.

Heikki> It is not the correct way to run SQL statements in the autocommit mode on
Heikki> the slave server, while the master has normal transaction processing on.

Heikki> I have asked Sasha to add COMMIT marks to the binlog, so that people would
Heikki> not see partial transactions on the slave server. I am sending a carbon copy
Heikki> of this message to Sasha.

Heikki> Best regards,

We have this in our todo and it will be fixed in MySQL 4.0 or 4.1.

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to