[Toolserver-l] Replag issues on new sql-s1 box
Ja Ga
jaga_x_1 at yahoo.com
Tue Mar 3 18:19:29 UTC 2009
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20090303/b7244359/attachment.htm
More information about the Toolserver-l
mailing list