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 <[EMAIL PROTECTED]> wrote: > Hi, > > On Thu, Mar 20, 2008 at 9:41 AM, Sid Lane <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn