use dewiki_p; select page_title, cl_to from page b, categorylinks, templatelinks where cl_from = b.page_id and tl_from = b.page_id and b.page_namespace = 0 and tl_from_namespace = 0 and tl_namespace = 10 and tl_title not in ( select page_title from page a where a.page_namespace = 10 ) order by page_title;
This query running on dewiki.analytics.db.svc.eqiad.wmflabs timeouts since April 26th or 27th 2020. This query lasts about 100 minutes, sometimes 70, sometimes 110 minutes.
Proposal: The databases are growing and growing and growing every day. It is necessary to increase the timeout time in accordance with it.