A job to cleanup the wbt_* terms table rows when they may not be needed any more.
More...
A job to cleanup the wbt_* terms table rows when they may not be needed any more.
This job currently executes in a single transaction.
Callers can choose to supply a single termInLang id to clean per job or multiple. Supplying multiple ids will naturally mean the Job and the transaction take longer and therefor locks will also be held for a longer period of time possibly causing lock contention. This started to show on wikidata.org in https://phabricator.wikimedia.org/T246898 and thus the default was switched for create a single job per termInLang id. For smaller Wikibase installs with a lower edit rate it might make sense to instead optimize for fewer jobs, where lock contention is less of an issue.
- Todo
- Execute the cleanup of each table in its own transaction to further reduce lock contention
- See also
- Item & Property Terms
- Author
- Addshore
- Copyright
- GPL-2.0-or-later