… to prevent problems with the replication you should change the binary log format to “row”. Depending on the statement, the behavior of… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the…. 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
…class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions …Group commit for the binary log makes the server much faster with the binary log enabled Faster …improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
…, This is different issue. In many versions Innodb would print wrong 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…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… XA, but also for internal XA coordination between the InnoDB transaction logs and the MySQL binary logs, to ensure that they are consistent. Consistent is… InnoDB performance. Having innodb_support_xa enabled on a replication master—or on any MySQL server where binary logging is in use—ensures that 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 volume. This number is for sync_binlog=0 and innodb_flush_log_at_trx_commit…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… somewhat similar functionality works as expected. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file… master, or later use for point in time recovery using binary log.
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… transaction. And the server performs an XA transaction between InnoDB and the binary log. This adds more fsync calls, and causes mutex contention…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… InnoDB, it is also important that your transaction logs…mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107 | +——————+———–+ 23 rows in set (0.00 sec) mysql…
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… INTO OUTFILE followed by LOAD DATA INFILE. You can use InnoDB instead. Or you can do something more elaborate and application…
Post: Just how useful are binary logs for incremental backups?
July 21, 2009 By 6 Comments
… before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of…? If you are using all InnoDB tables, an XtraBackup incremental backup should be much faster than using binary logs. You can understand… restore! Eventually this problem should be lessened by a MySQL Server feature – parallel execution on slaves. Lets hope that…
