<div class="gmail_quote">On Wed, Oct 26, 2011 at 9:50 AM, Ja Ga <span dir="ltr"><<a href="mailto:jaga_x_1@yahoo.com">jaga_x_1@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit" valign="top">So, is anyone else seeing really horrible mysql performance on s1? I heard a mysql upgrade introduced regressions, but I'm seeing queries take 2x - 3x as long, sometimes worse. <br>
</td></tr></tbody></table></blockquote><div><br>Yes. On the 25th, the following query of mine was killed after 1700 seconds:<br><br> SELECT ns_id, ns_name FROM toolserver.namespacename where (ns_type =
'canonical' or ns_type = 'primary') and dbname = 'enwiki_p' <br></div></div><br>That should be an extremely fast query; there is an index on dbname. I reported similar problems a little while ago on this list. I get many other notices about killed queries that should not have problems. <br>
<br>- Carl <br>