https://bugzilla.wikimedia.org/show_bug.cgi?id=33540
--- Comment #1 from Reedy <[email protected]> 2012-01-13 00:42:11 UTC --- mysql> explain select distinct pl_from from pagelinks left join page on page_id=pl_from where page_title is null +----+-------------+-----------+--------+---------------+---------+---------+--------------------------+----------+-----------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------+--------+---------------+---------+---------+--------------------------+----------+-----------------------------------+ | 1 | SIMPLE | pagelinks | index | NULL | pl_from | 265 | NULL | 65287380 | Using index; Using temporary | | 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | ptwiki.pagelinks.pl_from | 1 | Using where; Not exists; Distinct | +----+-------------+-----------+--------+---------------+---------+---------+--------------------------+----------+-----------------------------------+ 2 rows in set (0.00 sec) Can you give me a CSV list of page ids? And I can just do a delete where in list, as I'm not running that query on the cluster -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
