… setup. There are good reasons to have binary logs on NFS volume – binary logs is exactly the thing you want to survive the server crash – using… slave to this box the throughput on the Master drops to about 2800 updates sec…. which is very close to the magic number how… moved the Binary logs to the local storage I got very similar performance but there have been no degradation when replication is enabled. I…
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
… privilege bypass it. Looking into binary log is obvious choice – this is a good reason to have binary log on the slave if you do… at once. In many cases however log_slave_updates is enabled which makes slave to write all updates to binary logs – the ones executed directly on the host as well as coming through replication thread. There is however a way to…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… binary log position, you can replay the binary log and roll forward the state of your server to a desired point in time. But enabling the binary log reduces MySQL’s performance dramatically. It is not the logging itself that… a matter of how hard it is. It’s worth noting that PBXT does replication through its transaction logs, so there’s…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… (…) From that output you can learn how to run configure command, which needs to be done prior to compiling the sources. It should …apply the changes to the database configuration, specifically you need to enable slow logging (see Configuration section for details). Then rename the binary, which …
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll learn what problems can we have and how to…(YEAR(CURDATE())); Binary Logs: First the event gets logged to the Binary Log: CREATE …to promote a Slave to Master we will need to do some steps to enable…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to… to the binary log. They are called binary log events. A binary log event contains the server-id where it was executed. Then that event is replicated to… with slaves or if you want to backup one master, you need log_slave_updates[3] to be enabled. This is for example the…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
…to keep different transactonal storage engines in sync, 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…. So how you can solve the problem ? Disable binary log. …
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… statement, it writes the whole transaction to the binary log and then commits this transaction into…binary log ITSELF is XA-compliant:) I guess what I’m really asking is, if you have enabled binary logging… remain in the replication log? I guess I don’t understand how enabling xa-support would …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… Server release. It is also interesting to see how Flash cards will handle innodb_flush_log_at_trx_commit=1 and sync_binlog… you can see, enabling binary logs with system without writeback cache impacts performance significantly. And the similar with writeback cache enabled thread trx=1…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…. I’m however yet to give it real stress tests to see how well it performs 
One more thing to keep into account – INSERT… not using replication and have my binary log disabled ? If replication is not used you can enable innodb_locks_unsafe_for_binlog option… enough to trigger relaxed locks. You have to set innodb_locks_unsafe_for_binlog=1 as well. This is done so enabling binary log does…
