… was reading the part about replication, can you help re-affirm this statement about replication? I’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…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id… options cause phantom reads (non repeatable reads) so in order to prevent problems with the replication you should change the binary log format to… application can deal with phantom reads and your binary log is in row format, changing the ISOLATION to READ COMMITTED will help you to…
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-crash-safe-replication-in-50/ We have fixed it in Percona Server. Also if you’re doing FLUSH TABLES WITH READ…
Comment: Best kept MySQLDump Secret
March 25, 2012 By 11 Comments
…is not really a secret… Quoting MySQL manual from http://dev.mysql.com/doc/refman/5.5…a valid dump file (correct table contents and binary log coordinates), no other connection should use the … DROP TABLE, RENAME TABLE, TRUNCATE TABLE. A consistent read is not isolated from those statements, so…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… so-called “binary log” of events that modify data in the server. The binary log is a real limitation in MySQL. The binary log is necessary not… enabling the binary log reduces MySQL‘s performance dramatically. It is not the logging itself that’s the problem — writing the log is usually not…,” and it would have to be modified to be available read-only in this state so that it could be used…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6… fi touch $LASTFILE echo “Starting live binlog backup” $MBL –raw –read-from-remote-server –stop-never –host $MYSQLHOST –port $MYSQLPORT -u…
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… show you how to interpret SHOW SLAVE STATUS, how to read MySQL’s binary logs, and how to recover a replication slave from many…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… be serialized for the binary log; otherwise replaying the binary log can result in a different order of execution. The MySQL manual actually says this, but not in the clearest way. It just says If you are using the binary log, concurrent… read lock is what’s blocking the concurrent inserts from happening. There’s no solution to this, if you need the binary log…
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… a network roundtrip when the binary log is written at the same time as slave-feeding thread is reading it. I’d be…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL…to test things out – you can move read traffic to such slave to ensure new… before upgrading and make sure to keep binary logs for some time, in case you run…
