mysql auto_increment by 5?

Question

I'm running into a really, really, really weird problem with mysql.

I have a primary key, "id". It's set to auto increment. Problem is, first entry started at "3". And every new entry increases by 5, so the next entry's id is 8, the next is 13, then 18, so on. This is stupid. Why isn't it just incrementing by 1, like it should be? And why is it starting at 3???

Is there some setting somewhere I'm missing? I'm using phpmyadmin, if that helps.

Answer 1

The auto increment is probably set to 5. Try:

ALTER TABLE YourTable AUTO_INCREMENT = 1;

You can retrieve the current setting with:

SHOW TABLE STATUS LIKE 'YourTable'

See the MySQL docs for more details.

Answer 2

it appears the table was created with an increment set to 5. you can change it back to one with the following:

ALTER TABLE tbl AUTO_INCREMENT = 1;

Answer 3

There's a my.cnf configuration for that: auto_increment_increment. It's used for master-master server setups to prevent the same key from being defined twice by two different servers. So using that coupled with auto_increment_offset, it allows each server to always generate unique ids...

So, from what you're describing, it sounds like you have this:

auto_increment_increment = 5
auto_increment_offset = 3