Re: InnoDB is losing records, there are gaps in autoincrement sequence

2003-01-24 Thread Heikki Tuuri
Robert, yes, if there are multiple UNIQUE keys in a table, then in the REPLACE implementation there is a loop which DELETEs all records which have conflicting UNIQUE key values. Since you have kept the binlog of your database, you can rerun the SQL statements and try to find where your rows

Re: InnoDB is losing records, there are gaps in autoincrement sequence

2003-01-16 Thread Heikki Tuuri
Hi! - Original Message - From: My Deja [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, January 16, 2003 12:39 PM Subject: InnoDB is losing records, there are gaps in autoincrement sequence InnoDB appears to be losing records. The version I am using is 3.32.53