On Wed, Oct 26, 2011 at 9:50 AM, Ja Ga <jaga_...@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
_______________________________________________ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette