[Toolserver-l] performance issues

[Carl (CBM)]

On Wed, Oct 26, 2011 at 9:50 AM, Ja Ga <jaga_x_1 at yahoo.com> wrote:

> 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.
>

Yes. On the 25th, the following query of mine was killed after 1700 seconds:

  SELECT ns_id, ns_name FROM toolserver.namespacename  where (ns_type =
'canonical' or ns_type = 'primary') and dbname = 'enwiki_p'

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.

- Carl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20111026/5cf84d29/attachment.htm