…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… 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
…size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700… the concurrency and the performance you can disable them in two different ways: 1- Change …problems with the replication you should change the binary log format to “row”. Depending on the statement, …
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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var …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…
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… so you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log…
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… 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…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… on Master-Master setup do not forget to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE query. Replication… being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… VALUES(YEAR(CURDATE())); END;// mysql> CALL this_pyear(); Binary Log: #111213 23:33:41 server id 1 end_log_pos 2055 Query thread_id… alter every event adding DISABLE ON SLAVE. ALTER EVENT even_name DISABLE ON SLAVE. LOCAL VARIABLES Local Variables are logged as an extra…: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t VALUES(@this_year) Binary Log: #111213 23:58:11 server id 1 end_log…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… binary log is also disabled.) The prepare-then-commit process does two important things: it ensures that the binary log and the engine’s transaction log… a replication master—or on any MySQL server where binary logging is in use—ensures that the binary log does not get out of sync…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to… serialization. MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL‘s…, then InnoDB’s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is often not…
