Hi! -----Original Message----- From: Peter Zaitsev <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, January 05, 2002 10:35 PM Subject: Innodb/Replication problems.
>Hello mysql, > > I'm using mysql 3.23.47 with Innodb and trying to play around with > replication. The replication options are default. > > I got one table content occasionally deleted on slave, and note what Who deleted the table contents? You? > this did not stop the replication: The inserts are successfully > passed, therefore the updates to nonexistent rows simply ignored. But MySQL passes complete SQL statements to the slave. It is no error if an update does not update any rows. I do not believe that MySQL checks that the master updated as many rows as the slave. > I remember then I tried this half a year ago with myisam, the > behavior was to print an error and stop. > >SLAVE: > >mysql> select count(*) from counter.quickstat; >+----------+ >| count(*) | >+----------+ >| 661 | >+----------+ >1 row in set (0.04 sec) > >MASTER: > >mysql> select count(*) from counter.quickstat; >+----------+ >| count(*) | >+----------+ >| 294787 | >+----------+ >1 row in set (2.65 sec) > > > >-- >Best regards, > Peter mailto:[EMAIL PROTECTED] Regards, Heikki Tuuri Innobase Oy --- MySQL/InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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
