Page MenuHomePhabricator
Create Task
Maniphest T214661

Improve efficiency of Special:ProtectedPages (unavailable on enwiki with limit=1000, due to 60s execution timeout)
Closed, ResolvedPublic
Actions

Description

Opening https://en.wikipedia.org/wiki/Special:ProtectedPages reliably causes a timeout to happen, both on HHVM and PHP7, for me. This is because my preferences show 1000 entries by default, and the code is not yet efficient enough to handle this request within 60 seconds.

Related Objects

Event Timeline

ToBeFree created this task.Jan 25 2019, 1:35 AM
Krinkle renamed this task from Improve efficiency of Special:ProtectedPages (currently >60 seconds for 1000 entries @ enwiki) to Improve efficiency of Special:ProtectedPages (unavailable on enwiki with limit=1000, due to 60s execution timeout).Jan 25 2019, 1:37 AM
Krinkle edited projects, added MediaWiki-Special-pages; removed PHP 7.2 support.
Krinkle moved this task from To triage to SpecialPage system on the MediaWiki-Special-pages board.
Krinkle moved this task from Untriaged to Mar 2021 on the Wikimedia-production-error board.
Krinkle moved this task from SpecialPage system to Maintenance reports on the MediaWiki-Special-pages board.
Jdforrester-WMF subscribed.Jan 25 2019, 2:23 AM

Not sure that the parent relationship is warranted any more? Will leave in case Krinkle meant to leave it.

ToBeFree added a comment.Jan 25 2019, 3:47 AM

(I agree, we can remove this)

Aklapper mentioned this in T214660: PHP7 Timeout causes plaintext warning.Jan 25 2019, 10:30 AM
Krinkle removed a parent task: T214660: PHP7 Timeout causes plaintext warning.Feb 4 2019, 11:15 PM
• mmodell changed the subtype of this task from "Task" to "Production Error".Aug 28 2019, 11:07 PM
Krinkle edited projects, added Wikimedia-database-issue; removed Wikimedia-production-error.Mar 24 2020, 9:19 PM
Krinkle changed the subtype of this task from "Production Error" to "Task".Apr 9 2022, 6:56 PM
Krinkle edited projects, added Wikimedia-Slow-DB-Query; removed Wikimedia-database-issue.
Krinkle closed this task as Resolved.Apr 9 2022, 6:59 PM
Krinkle subscribed.

My preferences are not set to 1000, so I'm setting it in the query myself:

https://en.wikipedia.org/w/index.php?title=Special:ProtectedPages&limit=1000

This loads consistently for me in a second or two. I've confirmed that there are indeed ~1000 results based on there being a non-empty "next page" to navigate to, and based on ctlr-F for "Unknown user" yielding "1000 results" according to Firefox.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL