Hello,
I was looking at one of my tables and I noticed that the autoincrement on the column was incrementing by two and not 1. So all of the row id numbers are odd (e.g. 1,3,5,7...).

Is there a config setting that I did to make this happen?

Thanks!

your script to insert new rows is actually executing the INSERT statement twice, but the duplicates are getting rejected, and you don't notice it because you have IGNORE as an option on the INSERT statement

So, how do I know that it's adding data twice? Can I look in a log to verify this?

Thanks!

try adding a few rows directly into mysql, i.e. outside of your app

if they increment by 1, then it's your app that has the problem

I just used AquaData Studio and inserted a new row and I still get the increment of 2.

[wild shot in the dark]Are there any triggers on the table?[/wild shot in the dark]

What does this return:

Here is what I get back

auto_increment
-----------------
(null)
64

2 record(s) selected [Fetch MetaData: 2/ms] [Fetch Data: 0/ms]

[Executed: 1/5/10 8:58:53 AM PST ] [Execution: 4/ms]

please see MySQL :: MySQL 5.1 Reference Manual :: 16.1.3.2 Replication Master Options and Variables

i've never worked with master/slaves so i'm not familiar with this server setting, and i don't know if it can be applied to a single server

but at least this would explain the weird behaviour