Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
2  
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

 
discard

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

Browse other questions tagged or ask your own question.