[Wikidata-bugs] [Maniphest] [Commented On] T212690: DBQueryTimeoutError on Wikidata's Special:Nuke

[Marostegui]

Marostegui added a comment.

So this is the query:

SELECT  rc_namespace,rc_title,rc_timestamp  FROM `recentchanges`    WHERE ((rc_new = 1) OR (rc_log_type = 'upload' AND rc_log_action = 'upload')) AND ((rc_user = '24')) AND rc_namespace = '0'  GROUP BY rc_namespace, rc_title, rc_timestamp ORDER BY rc_timestamp DESC LIMIT 22

And this is the server that was failing was db1109

+------+-------------+---------------+------+-------------------------------------------------------------------------------------------------------------+----------------+---------+-------+----------+----------------------------------------------+
| id   | select_type | table         | type | possible_keys                                                                                               | key            | key_len | ref   | rows     | Extra                                        |
+------+-------------+---------------+------+-------------------------------------------------------------------------------------------------------------+----------------+---------+-------+----------+----------------------------------------------+
|    1 | SIMPLE      | recentchanges | ref  | new_name_timestamp,rc_ns_usertext,rc_name_type_patrolled_timestamp,rc_ns_actor,rc_namespace_title_timestamp | rc_ns_usertext | 4       | const | 10906882 | Using where; Using temporary; Using filesort |
+------+-------------+---------------+------+-------------------------------------------------------------------------------------------------------------+----------------+---------+-------+----------+----------------------------------------------+
1 row in set (0.00 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T212690

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: Addshore, Marostegui, Aklapper, abian, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, D3r1ck01, Wikidata-bugs, aude, Jdforrester-WMF, Mbch331, Jay8g, Glaisher, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs