…. Q: periodically the ALTER isn’t written to the bin-log and thus isn’t replicated, why ? without any replication filters… 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 10, 2012 By 28 Comments
I’m not suggesting to turn off the binary log. I think you have some assumptions that you may not have validated. The file that’s loaded on the master IS transmitted to replicas, in a number of special binary log events (of type “Load_file” if I recall correctly).
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
….5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down. If the load takes 4 hours… probably a good idea to turn off the session’s binary log in general. But if it’s left on, the replication…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
…’s loaded on the master is actually inlined into the binary log, and the replica writes out a copy of the file…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… every MySQL restart, the logs are flushed and a new binary log is created, looking at the current binary logs after restoring the snapshot, I… and skipping the DROP statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700… 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…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 24, 2012 By 20 Comments
… originate from either not having log files and data on the same partition or synchronization of binary log and innodb snapshot. In certain versions FLUSH TABLES WITH READ LOCK would not block “commit” operation which caused wrong binary log…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins…
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…
Comment: Best kept MySQLDump Secret
March 25, 2012 By 11 Comments
…, to ensure a valid dump file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER…
