Page MenuHomePhabricator

Implement Special:UpdateEditCounts as a maintenance script
Closed, ResolvedPublic

Description

The special page Special:UpdateEditCounts is used to populate and update the edit count displayed on the social profile of users.

This has at least a couple of problems:

  • Lack of automation. An authorized user needs to push a button whenever the counts need to be updated. Until then, the edit count is frozen.
  • It's not scalable. It does a count(*) on the entire revision table, grouping by actor. This is problematic on large wikis, specially when executed from the web interface, because there are time constraints, and slow queries like this risk getting killed by the PHP max_execution_time.

Creating a maintenance script will solve both problems (not directly the second, but would mitigate the timeout problem).

Event Timeline

Change 935994 had a related patch set uploaded (by Martineznovo; author: Martineznovo):

[mediawiki/extensions/SocialProfile@master] Implement Special:UpdateEditCounts as a maintenance script

https://gerrit.wikimedia.org/r/935994

Ciencia_Al_Poder changed the task status from Open to In Progress.Jul 6 2023, 10:51 AM
Ciencia_Al_Poder claimed this task.

Change 935994 merged by jenkins-bot:

[mediawiki/extensions/SocialProfile@master] Implement Special:UpdateEditCounts as a maintenance script

https://gerrit.wikimedia.org/r/935994