On Wed, Oct 26, 2011 at 9:50 AM, Ja Ga jaga_x_1@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