MaxSem added a subscriber: MaxSem.
MaxSem triaged this task as "Unbreak Now!" priority.
MaxSem added a comment.
This is causing über slow requests in production right now that time out after
60 seconds:
EXPLAIN SELECT
rev_id,rev_timestamp,page_namespace,page_title,rev_user,rev_user_text,rev_deleted,rev_page,page_latest,rev_comment,rev_minor_edit,rev_parent_id
FROM `page`,`revision` FORCE INDEX (usertext_timestamp) WHERE
(page_id=rev_page) AND ((rev_deleted & 4) != 4) AND (rev_user_text LIKE 'Tim%'
) AND (rev_timestamp<='20081010115959') AND (rev_timestamp>='20081010000001')
ORDER BY rev_user_text DESC,rev_timestamp DESC,rev_id DESC LIMIT 6;
+------+-------------+----------+--------+--------------------+--------------------+---------+--------------------------+---------+-------------+
| id | select_type | table | type | possible_keys | key
| key_len | ref | rows | Extra |
+------+-------------+----------+--------+--------------------+--------------------+---------+--------------------------+---------+-------------+
| 1 | SIMPLE | revision | range | usertext_timestamp |
usertext_timestamp | 273 | NULL | 2254294 | Using where
|
| 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY
| 4 | enwiki.revision.rev_page | 1 | |
+------+-------------+----------+--------+--------------------+--------------------+---------+--------------------------+---------+-------------+
2 rows in set (0.04 sec)
Please fix that or we will have to disable the API functionality used in miser
mode, effectively making it gone forever. And still breaking all your tests ;)
Example fixes could include querying a labs instance or at least testwiki, with
request tailored such that it doesn't cause outrageous table scans.
TASK DETAIL
https://phabricator.wikimedia.org/T78668
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: MaxSem
Cc: MaxSem, gerritbot, jayvdb, Aklapper, pywikibot-bugs-list, Malyacko
_______________________________________________
pywikibot-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/pywikibot-bugs
