…. Q: periodically the ALTER isn’t written to the bin-log and thus isn’t replicated, why ? without any replication filters… version of the tool does NOT have any features to disable the binary log; my experience has been that this is a very… tool, so there is no code in the tool that disables binary logging at all. Are you using the 2.0 version of…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… your transactions affecting the concurrency and the performance you can disable them in two different ways: 1- Change the ISOLATION level… 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 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…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… concurrent inserts even when there are holes, but it’s disabled by default.) However, that turned out not to be the…. The statements have to be serialized for the binary log; otherwise replaying the binary log can result in a different order of execution. The… clearest way. It just says If you are using the binary log, concurrent inserts are converted to normal inserts for CREATE … SELECT…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…\ imum number of threads allowed inside InnoDB. Value 0 will disable the thread t\ hrottling.”, NULL, NULL, 8, 0, 1000, 0… for semaphores in SHOW INNODB STATUS), you can try to disable thread throttling completely by setting the value 0. But if…, then InnoDB’s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is often not…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
…, together with binary log. XA is enabled if binary log is enabled this is why this issue is trigered by enabled binary log. if binary log is disabled, so… with large transactions. So how you can solve the problem ? Disable binary log. This could be option for slaves for example which do…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… options are somethat benchmark optimized – for example doublewrite is disabled; checksums are disabled; binary log is disabled – this is not what you would probably run… will likely be faster. query_cache_size = 0M – query cache disabled. Not a big surprise though as this is default value…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… keep old working code path if XA is disabled ? Many customers do not flush binary log anyway and use single transactional storage engine… Disable Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log… just was in “write through” cache policy, so was basically disabled. Note getting BBU is often good idea anyway so you…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… is if I’m not using replication and have my binary log disabled ? If replication is not used you can enable innodb_locks… use innodb_locks_unsafe_for_binlog option with caution. Note disabling binary logs is not enough to trigger relaxed locks. You have to…_for_binlog=1 as well. This is done so enabling binary log does not cause unexpected changes in locking behavior and performance…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 6 Comments
… and ROW replication contain the changes to the data in binary logs. This requires the data to be same on Master and… CHAIN/TREE replication. In this case you will need to disable binary logging while loading data from mysqldump as you may not want…
