https://bugzilla.wikimedia.org/show_bug.cgi?id=67602
--- Comment #3 from merl <[email protected]> --- I just divided another complex query into multiple queries for a performance test. This searches for included not existing images of a single article (there is only one image (Icon tools.svg) embedded in this article 8188489, so DF_temp has only one row): CREATE TEMPORARY TABLE IF NOT EXISTS DF_temp (it VARCHAR(255) PRIMARY KEY); DELETE FROM DF_temp; INSERT IGNORE INTO DF_temp (it) SELECT STRAIGHT_JOIN il_to FROM dewiki_p.page p1 INNER JOIN dewiki_p.imagelinks ON p1.page_id=il_from WHERE p1.page_id = 8188489; DELETE DF_temp FROM DF_temp INNER JOIN dewiki_p.image ON it=img_name; DELETE DF_temp FROM DF_temp INNER JOIN commonswiki_f_p.image ON it=img_name; The last query fails after the timeout of 10 minutes it set on labs. img_name is primary key, so also your condition "rows selected during a join are strictly constrained on indexed columns" is true here. There are also two additional queries checking for redirects to images. With these additional queries runtime on TS is about 0.08 seconds. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
