[Wikidata-bugs] [Maniphest] [Commented On] T179928: Spike: Investigate Long running queries from pltools unlikely to finish

Ladsgroup added a comment. My suggestion: T114904#3769427 Overall, I don't think is there anything we can do for now.TASK DETAILhttps://phabricator.wikimedia.org/T179928EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: LadsgroupCc: WMDE-leszek, Pasleim,

[Wikidata-bugs] [Maniphest] [Commented On] T179928: Spike: Investigate Long running queries from pltools unlikely to finish

Ladsgroup added a comment. The first query can be rewritten to use self join instead of subqueries that usually are more expensive: mysql:wikiadmin@db1087 [wikidatawiki]> explain SELECT ips_item_id, count(*) AS cnt FROM wb_items_per_site WHERE CONCAT("Q", ips_item_id) IN (SELECT page_title FROM