I don't see it here http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html so I suspect you may need a restart. Double-check that though.
mike wrote: > hate to be repetitive, but i also don't like bouncing production > databases (our mysql handles a lot more than our RT system)....do I > need to reload/restart mysql for the auto_increment_increment change > to take hold? our tickets are still incrementing n+10 rather than > n+1, and the slave's config is set for auto_increment_offset=2 rather > than 1 like the master is. > > thanks! > > > On 5/1/07, *mike* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > hmm....does this require a restart of mysql? It now *looks* > correct, but is still incrementing n+10? > > mysql> SHOW VARIABLES LIKE 'auto_inc%'; > +--------------------------+-------+ > | Variable_name | Value | > +--------------------------+-------+ > | auto_increment_increment | 1 | > | auto_increment_offset | 1 | > +--------------------------+-------+ > > I made this change as as the root/dba account, so I'm confused... > > > > On 5/1/07, *mike* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > yes indeed - the master is now set to > > mysql> SHOW VARIABLES LIKE 'auto_inc%'; > +--------------------------+-------+ > | Variable_name | Value | > +--------------------------+-------+ > | auto_increment_increment | 1 | > | auto_increment_offset | 1 | > +--------------------------+-------+ > > and the slave is > > mysql> SHOW VARIABLES LIKE 'auto_inc%'; > +--------------------------+-------+ > | Variable_name | Value | > +--------------------------+-------+ > | auto_increment_increment | 1 | > | auto_increment_offset | 2 | > +--------------------------+-------+ > 2 rows in set (0.00 sec) > > prior to making the change suggested, the master was > configured as: > > > Current database: rt3 > > +--------------------------+-------+ > | Variable_name | Value | > +--------------------------+-------+ > | auto_increment_increment | 10 | > | auto_increment_offset | 1 | > +--------------------------+-------+ > 2 rows in set (0.00 sec) > > do I need to reload mysql, or is this a hot-fix? needless to > say, i am not a DBA, let alone terribly cluey with MySQL (but > learning more every day) ;). > > Thank you very much for the assistance, it's very much > appreciated and I owe Mark Roedel a six-pack for the initial > assist :) > > > > > On 5/1/07, *Graham Dunn* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > mike wrote: > > Hello, > > > > Since upgrading to RT 3.6.3, I've noticed that all of our > tickets are > > incrementing their ticket numbers/IDs by n+10 - > > > Are you using multiple-master replication? > > > http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html > > <http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html> > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > <http://wiki.bestpractical.com/> > Commercial support: [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > Discover RT's hidden secrets with RT Essentials from > O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > <http://rtbook.bestpractical.com/> > > > > > -- > > -- > One way or another, everyone stops bleeding. > > > -- > -- > One way or another, everyone stops bleeding. > > > > > -- > -- > One way or another, everyone stops bleeding. > > > > > -- > -- > One way or another, everyone stops bleeding. > ------------------------------------------------------------------------ > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com -- Drew Barnes Applications Analyst Raymond Walters College University of Cincinnati _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
