… the part about replication, can you help re-affirm this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication …time of queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… as MySQL Restart – the traffic on different boxes might be different and hence cache content. Replication Traffic Changes Changing in the replication traffic… nice to analyze your replication traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means… out and slow down your batch job (such as adding sleep calls) to ensure there is enough breathing room for replication thread…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with slow query…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded …-digest with filter to only check queries from replication thread: mk-query-digest slow-log –filter ‘($event->{user} || “”) =~ m/[SLAVE_THREAD]/’ > /tmp… same as replication load. This gives us replication capacity of 1/0.37 = 2.70 This method should work with original MySQL Server…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
… just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not… to analyze slow query log to find what queries take up the most resources on your server – in certain configurations replication load… consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the slave and your replication is…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… durable. You have to have log-bin enabled to get replication or point in time recovery, but at the same time… you would see very strange behavior on 5.0 of MySQL being slow but few queries being “inside innodb” and potentially even… back but obviously you loose point in time recovery and replication. Use innodb_flush_log_at_trx_commit=2 This is…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 2 Comments
One may think one may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes… mentioned mysql slave queries are not logged to slow query log and it looks like I was wrong connecting it just with replication. In reality it is not the fact the thread is replication thread causes queries to be omitted from slow query…
