…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… the tool does NOT have any features to disable the binary log; my experience has been that this is a very dangerous…, so there is no code in the tool that disables binary logging at all. Are you using the 2.0 version of…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
…’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down… probably a good idea to turn off the session’s binary log in general. But if it’s left on, the replication…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id… to prevent problems with the replication you should change the binary log format to “row”. Depending on the statement, the behavior of…. If your application can deal with phantom reads and your binary log is in row format, changing the ISOLATION to READ COMMITTED…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins… more choice than ever — there are three great versions of MySQL that suit different needs and personalities, with different characteristics, and…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… position for current binary log (especially if it is disable) and not print the position of slave thread in master logs at all. Here is some old post of mine about it: http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql…
Comment: Best kept MySQLDump Secret
March 25, 2012 By 11 Comments
… Peter! It is not really a secret… Quoting MySQL manual from http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html…, to ensure a valid dump file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… the binary log files which could still lead to data loss depending on the interval you back them up. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… such setup. There are good reasons to have binary logs on NFS volume – binary logs is exactly the thing you want to survive the… of contention issues in MySQL 5.0 rather than any NAS issues. This number was reachable even with binary log stored on NFS volume. This number is for sync_binlog=0 and innodb_flush_log_at_trx_commit…
Post: What is exec_time in binary logs?
January 31, 2011 By 2 Comments
If you’ve used MySQL‘s mysqlbinlog tool, you’ve probably seen something like the …. This gets logged into the binary log and copied to replicas for replay. Now suppose that you have also set log_slave_updates on the replica. When the statement executes in the replication thread, it will be logged to the replica’s binary log…
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… a Percona Consultant speak on Replication. “Replication is one of MySQL’s most widely-used features, and despite significant improvements over… or external to your MySQL database. For those who do not have a thorough understanding of the MySQL binary log format or the slave… you how to interpret SHOW SLAVE STATUS, how to read MySQL’s binary logs, and how to recover a replication slave from many…
