…’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down… source and it’s probably a good idea to turn off the session’s binary log in general. But if it’s left on…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…binaries for MySQL 5.0.67 build 10 which include next fixes: We addressed concerns about potential logging…mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering of user statistics. With both slow_query_log = OFF…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… problems spotted and in the meanwhile we go over binary logs for the last month to see how frequently this … MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL … simply to hook up old MySQL 5.0 and all it slaves as a slave off new master and keep…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
… to turn off the general query log without restarting mysql – i moved the log file aside, touched a replacement, but didn’t give the mysql user write permision to it. I then used mysqladmin to flush all the logs, and when it… mysqlbinlog to extract the rest of the data from the binary logs, up until the start point. I could actually see the…
