agravayne Posted April 3, 2008 Share Posted April 3, 2008 Hello All, Have some strange behaviour happening. We recently moved our mysql from mac-osx to centos and everything works fine except the auto-increment keys are now incrementing by a factor of 10 instead of 1. Has anyone got any ideas why or where this can be set properly? Many thanks Scott Quote Link to comment Share on other sites More sharing options...
rhodesa Posted April 3, 2008 Share Posted April 3, 2008 Check this server config: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_auto-increment-offset Quote Link to comment Share on other sites More sharing options...
rhodesa Posted April 3, 2008 Share Posted April 3, 2008 Sorry, meant this one: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_auto-increment-increment Quote Link to comment Share on other sites More sharing options...
aschk Posted April 3, 2008 Share Posted April 3, 2008 I'm guessing that you're not hosting the database yourself? It sounds like a common technique now employed by hosts to produce round-robin database record writing. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.