Maniphest T318604

Add new externallinks fields
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ladsgroup
	Sep 26 2022, 5:50 PM

Tags

Referenced Files

None

Subscribers

Description

According to the parent task, adding el_to_domain_index and el_to_path to externallinks table. Plus adding the indexes: One on el_to_domain_index, el_to_path and one on el_to_domain_index, el_from. el_to_domain_index will collect up to 255 characters (or 127?)

Details

	Subject	Repo	Branch	Lines +/-
	schema: Add new fields for externallinks so we can reduce duplication	mediawiki/core	master	+188 -9

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Bawolff	T130058 Special:LinkSearch fails over 10,000
		Open		None	T47237 LinkSearch uses numeric offset paging instead of paging by last entry returned
		Resolved		Ladsgroup	T17218 LinkSearch results should use as much of the path as is provided, not simply search by domain
		Resolved	Feature	Ladsgroup	T14810 Special:Linksearch should default to all protocols (protocol-less column for externallinks)
		Resolved		Ladsgroup	T312666 Remove duplication in externallinks table
		Resolved		Ladsgroup	T318604 Add new externallinks fields

Event Timeline

Ladsgroup created this task.Sep 26 2022, 5:50 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 26 2022, 5:50 PM

Ladsgroup mentioned this in T318605: Deploy new externallinks fields to production.Sep 26 2022, 5:51 PM

Krinkle moved this task from Limbo to Perf recommendation on the Performance-Team (Radar) board.Sep 26 2022, 8:32 PM

Marostegui triaged this task as Medium priority.Sep 29 2022, 12:26 PM

Marostegui moved this task from Triage to Ready on the DBA board.

Change 836825 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):

[mediawiki/core@master] schema: Add new fields for externallinks

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

gerritbot added a project: Patch-For-Review.Sep 29 2022, 2:01 PM

Ladsgroup moved this task from Ready to In progress on the DBA board.Sep 29 2022, 2:02 PM

Krinkle edited projects, added MediaWiki-Page-derived-data; removed Performance-Team (Radar).Sep 29 2022, 2:49 PM

Krinkle unsubscribed.

Change 836825 merged by jenkins-bot:

[mediawiki/core@master] schema: Add new fields for externallinks so we can reduce duplication

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

ReleaseTaggerBot added a project: MW-1.40-notes (1.40.0-wmf.7; 2022-10-24).Oct 18 2022, 5:00 PM

Maintenance_bot removed a project: Patch-For-Review.Oct 18 2022, 5:30 PM

Ladsgroup closed this task as Resolved.Oct 25 2022, 11:53 AM

Ladsgroup moved this task from In progress to Done on the DBA board.