[Labs-l] Empty Cat query

• Previous message: [Labs-l] [Discussion needed] Process for taking over abandoned tools
• Next message: [Labs-l] Empty Cat query
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all,

I have a query [1] which I run weekly to identify empty categories; those
that don't have interwiki links and stay empty for a while are then deleted
by a sysop.

The query ran just fine every week until Sep 2nd. [2] Since then, the query
times out and the page doesn't get updated.

The query is no that complex (a SELECT with five JOINs) and used to finish
in about 3-5 minutes. I don't have EXPLAIN access on Labs so I cannot tell
what is slowing it down. Can someone kindly take a look and advise why this
suddenly stopped working?

Thanks,

Huji

[1] https://quarry.wmflabs.org/query/3760
[2]
https://fa.wikipedia.org/w/index.php?title=%D9%88%DB%8C%DA%A9%DB%8C%E2%80%8C%D9%BE%D8%AF%DB%8C%D8%A7:%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4_%D8%AF%DB%8C%D8%AA%D8%A7%D8%A8%DB%8C%D8%B3/%D8%B1%D8%AF%D9%87%E2%80%8C%D9%87%D8%A7%DB%8C_%D8%AE%D8%A7%D9%84%DB%8C&action=history&uselang=en
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20160923/5dc55384/attachment.html>

• Previous message: [Labs-l] [Discussion needed] Process for taking over abandoned tools
• Next message: [Labs-l] Empty Cat query
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]