MySQL 4.1 Binary Log name change

We recently made the jump to MySQL 4.1 at SitePoint and it’s mostly been smooth sailing. Though I have to admit that it hasn’t offered any of the performance increases that I had hoped for.

Just a heads up – as I’ve not seen this covered anywhere yet – that the default filenames created by the binary logger have changed.

In all prior versions, they were of this format:

Where xxx increments by 1 every time the logs are rotated. 001, 002, 003, etc.

(Note that the “mysql_update_log” prefix is configurable)

In MySQL 4.1, however, they are of this format:

The point obviously being to cater for installations that reset the counter a lot less frequently than we do. We never get beyond 30 before a complete snapshot and a restart of update logging.

This of course broke our script that compresses these (enormous) logfiles for backup purposes and required a little Friday hack to get back on track.

No mention of this behavioural change in the 4.0 -> 4.1 upgrade FAQ.


Category: open source Time: 2005-06-30 Views: 1

Related post

  • Error reading MySQL 5.5 binary log using mysqlbinlog 2012-07-02

    I'm having some trouble with a replication setup I'm using. It has been working fine for months, and then over the weekend, the slave stopped reading updates from the masters binlog with an error Got fatal error 1236 from master when reading data fro

  • MySQL, check & enable binary logs 2012-03-06

    I am running MySQL 5.1.47 on CentOS. How do I check if binary logging for InnoDB is active? How do I enable binary logging if they are not enabled? Just run? mysqld --log-bin --------------Solutions------------- Check if binary logging is active: mys

  • MySQL - Partially restore binary log 2012-08-21

    I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500. How can I do that? --------------Solutions------------- Use the mysqlbinlog utility mysqlbinlog --help gives the follow

  • mysql xtrabackup missing binary logs 2014-06-20

    It seems xtrabackup is not backing up binary logs, although it creates xtrabackup_binlog* with apparently correct information inside. Should the binary logs be copied manually beforehand or is this a bug? --------------Solutions------------- When usi

  • MySQL : Till when MySQL retains binary logs? 2014-01-09

    I have multiple queries : Till when does MySQL retain the binary logs ? What is the default setting ? When does it start logging ? What does the number of the binary log file name suggest for example in mysql-bin.xxxxxx what does xxxxxx signify. I ha

  • MySQL: Incorrect binary log format - OFF.000 2015-06-10

    I have a Percona MySQL 5.5.30 as a master(Debian 6.0.7). I got a weird issue that all my binary logs started saving in format OFF.00* instead of the specified format in .cnf file. mysql> show binary logs; +------------+------------+ | Log_name | File

  • What could cause a record to appear in the MySQL binary log but not the original table? 2015-08-06

    I have a web application (CiviCRM) that has the option to enable binary logging, which I've done. We use this software to record donations, including automatic recurring donations. Our payment processor sends a POST request to a particular URL, which

  • Amazon RDS use mysqbinlog error "Could not find first log file name in binary log " 2015-08-25

    We use RDS at AWS to manage our MySQL database, and EC2 for our web application server. I know that RDS creates binary logs used for replication.. and I use "SHOW BINARY LOGS;" check all available bin log files, there are some log files! I want

  • Anyway to identify mysql slaves have read upto which binary logs 2015-08-27

    I have multiple slaves reading from one master.. But few of them are keep disconnecting due to network issue. Is there any way that i can make sure before setting up the bin log purging script on master that all the slave have read upto certain bin l

  • Mysql binary logs not rotating, partition out of space, replication-related admin queries hang 2011-03-16

    I've got a box where the root partition is full. The most immediate explanation is the mysql binary logs aren't rotating. Despite expire_log_days being set to 10, there are logs older than 10 days. show master status, show slave status, and purge bin

  • Automatically purging binary logs 2015-03-14

    I'm currently trying to create an scheduled event on MySQL to purge binary logs every week. The create event statement is as follows: CREATE EVENT purgebinlogs ON SCHEDULE EVERY 1 WEEK STARTS CONCAT(CURRENT_DATE + INTERVAL 7 - WEEKDAY(CURRENT_DATE) D

  • commit statement missing for a dml statement in binary log 2016-03-02

    I have noticed 'commit' statement missing for a DML statement in binary log. Does it mean that this statement is rolled back in server? I am using mysql 5.5.40. sample binlog at 159527792 160229 23:25:22 server id 104 end_log_pos 159528127 Query thre

  • MySQL Binary Log activated = high-end server damn slow 2011-05-20

    On MySQL 5.1(.57-1.dotdeb), I have a ~2.0Gb database, and an average of ~350 requests per second. All is running fine if I don't activate the binary log. The CPU usage is decent (~15% of 1 CPU core). And if I activate the binary log, all is suddenly

  • Change path for binary logs and scheduling 2011-08-04

    I want to change the default name of binary log and path. I saw the documentation where it discusses about base_name. However, I just need to confirm how to use it correctly. I want binary logs to be stored on another partition and also want to sched

  • Replication - Binary log parsing(Tableid generation, ON DELETE CASCADE handling, Changed columns for update event) 2013-10-21

    I am using MySQL 5.5 with InnoDB engine. I have set binlog format as row-based replication. I have some doubts regarding replication: 1) How is the tableID generated? Is it stored somewhere? 2) Say I have Table T1(parent), T2(child), T3(child). T1 ha

  • MySQL:How to correct a corrupted MySQL binary log on Master server? 2014-01-08

    We are using MySQL DB with one master and one slave. We are using this setup for months now. The slave sync stopped today and the error we got was: Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:

  • Disable MySQL binary logging with log_bin variable 2014-07-30

    Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled: log_bin = /var/log/mysql/mysql-bin.log When I want to disable binary logging on such installation, comment out t

  • How to use Binary Log file for Auditing and Replicating in MySQL? 2010-04-07

    How to use Binary Log file for Auditing in MySQL? I want to track the change in a DB using Binary Log so that I can replicate these changes to other DB please do not give me hyperlinks for MySQL website. please direct me to find the solution EDIT I h

  • Problems with enabling MySQL binary logging in Windows 2010-09-19

    I am trying to enable binary logging on my Windows based MySQL server. I can enable it on my Linux system, but I keep getting errors when trying to invoke mysqld.exe with the --log-bin option. c:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld.exe --

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 0.701 (s). 13 q(s)