do binlog sequences just rollover back to 0 w/o a resetlogs? will it just
automatically go back to mysqld.000000 after mysqld.999999? any replication
implications?

I know it sounds like a stupid question and I'm sure the developers are
smart enought to have thought of that but we'll be crossing that threshold
in the next 6-8 weeks and I don't need to find out it's a problem the hard
way.

we're running 5.0.27 for most of our prod...

Hi,

On Thu, Mar 20, 2008 at 9:41 AM, Sid Lane <jakes.dad@gmail.com> wrote:
> do binlog sequences just rollover back to 0 w/o a resetlogs? will it just
> automatically go back to mysqld.000000 after mysqld.999999? any replication
> implications?
>
> I know it sounds like a stupid question and I'm sure the developers are
> smart enought to have thought of that but we'll be crossing that threshold
> in the next 6-8 weeks and I don't need to find out it's a problem the hard
> way.

I'm not sure what happens. But you can test: shut down a test
installation, create mysqld.999998, edit the mysqld.index file
appropriately, and restart. Then see what happens when you run FLUSH
LOGS a few times.

This is my test
13795620 8.0K -rw-rw---- 1 mysql mysql 146 Mar 21 17:58 mysql.1000000
13795622 8.0K -rw-rw---- 1 mysql mysql 146 Mar 21 17:58 mysql.1000001
13795623 8.0K -rw-rw---- 1 mysql mysql 106 Mar 21 17:58 mysql.1000002


On Thu, Mar 20, 2008 at 10:08 PM, Baron Schwartz <baron@xaprb.com> wrote:

> Hi,
>
> On Thu, Mar 20, 2008 at 9:41 AM, Sid Lane <jakes.dad@gmail.com> wrote:
> > do binlog sequences just rollover back to 0 w/o a resetlogs? will it
> just
> > automatically go back to mysqld.000000 after mysqld.999999? any
> replication
> > implications?
> >
> > I know it sounds like a stupid question and I'm sure the developers are
> > smart enought to have thought of that but we'll be crossing that
> threshold
> > in the next 6-8 weeks and I don't need to find out it's a problem the
> hard
> > way.
>
> I'm not sure what happens. But you can test: shut down a test
> installation, create mysqld.999998, edit the mysqld.index file
> appropriately, and restart. Then see what happens when you run FLUSH
> LOGS a few times.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=y...0608@gmail.com
>
>


--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn