Replace transcache table with objectcache backend
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	TK-999
	Mar 14 2018, 4:38 PM

Description

Currently, interwiki template transclusions are cached in the transcache table. This implementation has several drawbacks:

There is no garbage collection logic - the transcache table will continue to grow in size as the wiki evolves
Large templates can cause a database error depending on settings, if they do not fit into the transcache table
In a multi-wiki environment, responses for the same template are cached and duplicated on each wiki

I'd like to propose to generify caching of interwiki transclusion logic, and provide an alternative backend, such as one based on the ObjectCache implementation configured for the wiki (while keeping the original implementation available). Having an ObjectCache based transclusion cache fits the purpose of the transclusion cache being an actual cache, and will solve the aforementioned issues with cache garbage collection and duplicate entries.

Details

	Subject	Repo	Branch	Lines +/-
	Drop the transcache table from the schema	mediawiki/core	master	+5 -90
	Make interwiki transclusion use the WAN cache	mediawiki/core	master	+74 -33

Customize query in gerrit

Related Objects

Mentioned Here: T6547: Support crosswiki template inclusion (transclusion => interwiki templates, etc.)
T11890: Reasonably efficient interwiki transclusion
T14401: Scary transclusion is non-intuitive and unreliable

Event Timeline

TK-999 created this task.Mar 14 2018, 4:38 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 14 2018, 4:38 PM

I'll gladly work on this if it is deemed to be acceptable.

Yeah, the only reason created this separate ticket since it represents an improvement that can be done within the bounds of the existing interwiki transclusion system without requiring an extensive overhaul or migration process.

In T189702#4050499, @TK-999 wrote:

I'll gladly work on this if it is deemed to be acceptable.

@TK-999: Thanks for your interest!
CC'ing @aaron as he's listed for Cache on mw:Developers/Maintainers.
@aaron: Any input / guidance / opinions (or an idea who could provide them)?

Change 439316 had a related patch set uploaded (by Aaron Schulz; owner: Aaron Schulz):
[mediawiki/core@master] [WIP] Make interwiki transclusion use the WAN cache

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

gerritbot added a project: Patch-For-Review.Jun 8 2018, 9:26 PM

Krinkle renamed this task from Provide alternative interwiki transclusion cache backends to Replace transcache table with objectcache backend.Jul 28 2018, 8:42 PM

Krinkle assigned this task to aaron.

Krinkle added projects: MediaWiki-Templates, Performance-Team.

Krinkle added a project: Core-Platform-Team-Old.

Krinkle removed a project: MediaWiki-libs-BagOStuff.

TK-999 awarded a token.Jul 30 2018, 12:47 PM

aaron triaged this task as Low priority.Jul 30 2018, 8:12 PM

aaron moved this task from Inbox, needs triage to Blocked (old) on the Performance-Team board.

CCicalese_WMF moved this task from Inbox to Watching on the Core-Platform-Team-Old board.Jul 31 2018, 1:21 AM

Nemo_bis awarded a token.Aug 27 2018, 7:35 PM

Nemo_bis subscribed.

Change 439316 merged by jenkins-bot:
[mediawiki/core@master] Make interwiki transclusion use the WAN cache

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

ReleaseTaggerBot added a project: MW-1.32-notes (WMF-deploy-2018-08-28 (1.32.0-wmf.19)).Aug 27 2018, 10:00 PM

Reedy removed a project: Patch-For-Review.Aug 28 2018, 9:19 AM

Change 455875 had a related patch set uploaded (by Aaron Schulz; owner: Aaron Schulz):
[mediawiki/core@master] Drop the transcache table from the schema

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

gerritbot added a project: Patch-For-Review.Aug 28 2018, 5:44 PM

Krinkle added a project: MediaWiki-libs-Rdbms.Aug 28 2018, 6:16 PM

Krinkle moved this task from Untriaged to Schema changes on the MediaWiki-libs-Rdbms board.

Change 455875 merged by jenkins-bot:
[mediawiki/core@master] Drop the transcache table from the schema

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

ReleaseTaggerBot edited projects, added MW-1.32-notes (WMF-deploy-2018-09-04 (1.32.0-wmf.20)); removed MW-1.32-notes (WMF-deploy-2018-08-28 (1.32.0-wmf.19)).Sep 1 2018, 8:00 PM

aaron closed this task as Resolved.Sep 2 2018, 9:26 PM