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 Link to comment https://forums.phpfreaks.com/topic/99369-odd-auto-increment-behaviour/ 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 Link to comment https://forums.phpfreaks.com/topic/99369-odd-auto-increment-behaviour/#findComment-508405 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 Link to comment https://forums.phpfreaks.com/topic/99369-odd-auto-increment-behaviour/#findComment-508407 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. Link to comment https://forums.phpfreaks.com/topic/99369-odd-auto-increment-behaviour/#findComment-508541 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.