…of my slide deck, is now available. You can watch the recording and get the slides here. I …table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I…tool does NOT have any features to disable the binary log; my experience has been that this is a very…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… manual filtering – using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege… in advanced cases allowing replication to control what will be logged to binary log and so replicated. On the Slave you have more… to watch out for this one as well. As you can see no matter which road you take with partial MySQL Replication…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…have you ever wondered what servers are in your MySQL replication hierarchy? We have, too. As consultants, …only Filters replicate_wild_ignore_table=foo%.mount% Binary logging ROW Slave status 0 seconds behind, running, no…win a free ticket to Percona Live London? Watch our @percona Twitter stream to …
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… of sync with binary log and it is not easy to find which. I’m surprised to read enabling binary log drops update performance. I guess Jeremy speaks about enabling binary log and setting sync_binlog option which… certain disks to flush their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group commit…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… do not forget to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE…of the master capacity to the slave. So watch your replication and see if it getting overloaded…Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging …
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… too much overhead as XA already used for synchronizing with binary log. The focus of PBXT and one if it strengths seems… PostgreSQL, MySQL has finally got a storage engine which needs VACUUM” So overall PBXT is very interesting project to watch and to try out (We’re using PBXT with MySQL 5.1 in one of…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…. This however will be again behavior change to watch out for. So these are all possibilities but… we should test them and make binaries with them available. With current MySQL 5.0 I still see… performance such as multiple purge threads or parallel log recovery features, which he however needs to test…
Comment: Group commit and XA
May 27, 2006 By 8 Comments
[...] Watch out for MySQL 5.0 - if you enabled Binary log with MySQL 5.0 you loose group commit which can dramatically increase commit rate for multiple user load. See this post by Vadim for benchmark results. [...]
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…, depending on the hardware, you will be sitting idle and watching tons of text scrolling through the screen. The process should… to have the patched MySQL installed in the system. Locate where the original mysqld binary is with: (garfield:~/work/mysql-5.0.51a… to enable slow logging (see Configuration section for details). Then rename the binary, which can be safely done even with MySQL still running…
