[rt-users] Re: InnoDB Ticket IDs incrementing by 10?
mike
mike at bseder.org
Wed May 2 14:29:59 EDT 2007
yep, found and changed those values on both master and slave dbs in
my.cnfafter reading more through the docs to make sure i don't
miss/screw up
anything doing my DB restarts. i have a reload of both mysql
daemons scheduled for my next maintenance window, which should put this to
bed once and for all. there are no good reasons for any of the other tables
to be auto_incrementing n+10, so this should sort it out. i really need to
brush up on my mysql skills....i appreciate the clues, cheers guys and gals.
mike
On 5/2/07, Graham Dunn <gdunn01 at harris.com> wrote:
>
> 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.
> >
>
> The values will revert to their defaults if you've restarted mysql. Do
> you have those values set in the my.cnf?
>
> "If one of these variables is set globally, its effects persist until
> the global value is changed or overridden by setting them locally, or
> until mysqld is restarted.
>
> If set locally, the new value affects AUTO_INCREMENT columns for all
> tables into which new rows are inserted by the current user for the
> duration of the session, unless the values are changed during that
> session."
>
> Are you setting them to different values on different hosts on purpose?
>
> If so, it sounds like you're seeing the "set locally" behaviour.
>
>
> > thanks!
> >
> >
> > On 5/1/07, *mike* <mike at bseder.org <mailto:mike at bseder.org>> 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* <mike at bseder.org <mailto:mike at bseder.org>> 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* <gdunn01 at harris.com
> > <mailto:gdunn01 at harris.com>> 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: sales at bestpractical.com
> > <mailto:sales at bestpractical.com>
> >
> >
> > 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: sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
--
--
One way or another, everyone stops bleeding.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070502/8eb1b5c8/attachment.htm>
More information about the rt-users
mailing list