Now that sql-s1 is on a new box, my queries are creating a replag that
never happened before. For instance, I run a query that creates an
ENGINE=MEMORY table based on a join with enwiki_p.pagelinks and another
MEMORY-based table, typically takes 10-15 minutes. I ran this query daily for 1-2 months before the switch, and it never affected replag. Now, replag goes up as soon as the join begins. (Oh, and I call SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED) Is anyone else seeing problems like this? Or have an idea how to fix/work around the bug? - Jason |