Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I use MariaDB 5.5. It increases every auto_increment value by 2. So all my ai cols look like 1 3 5 7 9 ...
Where can I change this behaviour? Or might this be a bug?

share|improve this question
Is the instance part of replication (master)? Check the auto_increment_increment system variable. It is often set to 2 (or larger) when you have more than 1 masters in a replication, either explicit or implicit (liek you have more than one isolated servers and you plan to merge the data later). In combination with the auto_increment_offset, results in distinct values across servers in the auto-increment columns. – ypercubeᵀᴹ Apr 4 '13 at 8:23
I'd like to accept your comment as answer! I indeed use this server as part of replication (master in a master-slave relationship with 1 master). All I had to do was change the value in the config file! Thank you. – Marco Alka Apr 4 '13 at 8:57
@ypercube : Pls add ur comment as an answer, since the asker already accepts it.:) – Praveen Prasannan Apr 4 '13 at 11:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.