[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