I’m not suggesting to turn off the binary log. I think you have some assumptions that you may not have validated. The file that’s loaded on the master IS transmitted to replicas, in a number of special binary log events (of type “Load_file” if I recall correctly).
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… show what you’ve said and I do agree that turning off session binlog is the right strategy to go with. But…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… the source and it’s probably a good idea to turn off the session’s binary log in general. But if it…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… the current my.cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf After…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
It may not even be using that my.cnf file. Or you may have the options in the wrong section of the file.
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…) This works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my… 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file…
Comment: Choosing proper innodb_log_file_size
May 15, 2012 By 12 Comments
… user’s VM doing heavy activity on the disk. Also, my DB has also slowed down other user’s apps. IMO… out on a copy / testing DB in peak time and off-peak hours for your location. VPS and shared hosting are…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… the box, while XFS required poorly documented knobs to be turned and still couldn’t beat ext4: http://blog.tsunanet.net… another benchmark. What I found with XFS is that, to my great surprise, changing the number of allocation groups, setting the…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the recording… implemented. Q: periodically the ALTER isn’t written to the bin-log and thus isn’t replicated, why ? without any replication… does NOT have any features to disable the binary log; my experience has been that this is a very dangerous thing…
