Carl (CBM) wrote:
I am getting a lot of emails about the following query
taking too long
and being killed on thyme:
SELECT ns_id, ns_name FROM toolserver.namespacename where (ns_type
= 'canonical' or ns_type = 'primary') and dbname = 'enwiki_p'
Some of these emails claim that query ran over 3000 seconds. This
particular query should be quite fast. Is something up with the db
server?
I've had some issues recently with MySQL as well. My working theory is that
there have been (serious) regressions in recent point releases of MySQL,
particularly related to subqueries and subexpressions. I've had all sorts of
queries hanging (and even causing a pile-up leading to max_connections
errors) within the past few weeks.
Looking at your query, my first and best bet would be that it's the OR
clause that's causing you grief. I'd rewrite the query to be:
SELECT
ns_id,
ns_name
FROM toolserver.namespacename
WHERE ns_type IN ('primary', 'canonical')
AND dbname = 'enwiki_p';
If the problem persists with a rewritten query, it'd be quite surprising.
MZMcBride