it's impossible change increment step. " Thanks for contacting us. The auto increment steps are set this way as part of our replication strategy, so that we may grow the Heroku clusters that we operate. You'll also notice that if you insert rows on different endpoints that you were provided that the increment seed is different from one another - this is by design. " this is email from clear db support.
On Thursday, December 20, 2012 2:04:17 AM UTC+9, Brendan McCue wrote: > > Is it possible to change or work around the increment step being 10? > If i modify the my variable for auto_increment_increment to 1 it just goes > back to 10. > This is how i'm checking and changing the value. > > SHOW VARIABLES LIKE 'auto_inc%'; > SET @@auto_increment_increment=1; > > Also if not, you mentioned the replication policy they have. Do you have a > link to this? > Please and thank you. > > > On Monday, January 16, 2012 10:26:27 PM UTC-4, Chang Hoon Jeong wrote: >> >> i have experience use ClearDB on Heroku. >> >> - default mysql engine is MyISAM. if you want another engine, modify >> migration file. >> - default charset is ascii. if you want utf-8, modify migration file >> - auto increment step size is 10. because their replication policy. (ex, >> id is 11.. 21.. 31... 41.. not 1, 2, 3, 4) >> >> i use ClearDB for personal project so don't know about performance. >> > -- You received this message because you are subscribed to the Google Groups "Heroku" group. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en