Background: in T142936: Generate Special:LonelyPages on a more regular basis, we switched very slow enwiki QueryPages from biyearly to monthly. Currently the config looks like:
# Disable all the query pages that take more than about 15 minutes to update # Specify a "run mode" when a cron job is set up for the special page and # also create a message for the "run mode" in WikimediaMessages extension with # the message key 'querypage-updates-<run mode>' # wgDisableQueryPageUpdate @{ 'wgDisableQueryPageUpdate' => [ 'default' => [ 'Ancientpages' => 'half-monthly', 'Deadendpages' => 'half-monthly', 'Fewestrevisions' => 'half-monthly', 'Mostlinked' => 'half-monthly', 'Mostrevisions' => 'half-monthly', 'Wantedpages' => 'half-monthly', ], 'small' => [], // T45668 'medium' => [], // T48094 // Individual wikis ' enwiki' => [ 'Lonelypages' => 'monthly', 'Mostcategories' => 'monthly', 'Mostlinkedcategories' => 'monthly', 'Mostlinkedtemplates' => 'monthly', 'Uncategorizedcategories' => 'monthly', 'Wantedtemplates' => 'monthly', ], ... ],
For whatever reason, whether it's MediaWiki schema changes, better hardware, etc., these pages are much faster now.
- Lonelypages: 8 minutes
- Mostcategories: 6-7 minutes
- Mostlinkedcategories: no longer expensive, the cronjob literally does nothing.
- Mostlinkedtemplates: 20-24 minutes
- Uncategorizedcategories: 1-3 minutes
- Wantedtemplates: 10-13 minutes
Question for DBA: can we move these pages to the standard update timeline (every 3 days) now? Note that in T307314#7997375 I've already asked to increase that frequency over time to daily. If we need to leave Mostlinkedtemplates on the slow queue that would be understandable.