Maniphest T401912

Duplicate rc_name_type_patrolled_timestamp index on rc_source
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ladsgroup
	Aug 14 2025, 11:07 AM

Project Tags

Referenced Files

None

Subscribers

Description

We are deprecating and retiring rc_type, to do that, we need to duplicate this index (INDEX rc_name_type_patrolled_timestamp (rc_namespace, rc_type, rc_patrolled, rc_timestamp ) but instead of rc_type, it should be rc_source.

Details

Related Changes in Gerrit:

	Subject	Author	Repo	Branch	Lines +/-
	Add new rc_name_source_patrolled_timestamp index to recentchanges	Zabe	mediawiki/core	master	+819 -0

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T90435 [Epic] Wikidata watchlist improvements (client)
		Resolved		None	T400696 FY25-26 WE1.4.1 RecentChanges database performance improvements
		Resolved		Zabe	T74157 [Story] Use rc_source and drop rc_type
		Resolved		Zabe	T401912 Duplicate rc_name_type_patrolled_timestamp index on rc_source

Event Timeline

Ladsgroup created this task.Aug 14 2025, 11:07 AM

Restricted Application added projects: Data-Engineering, Moderator-Tools-Team. · View Herald TranscriptAug 14 2025, 11:07 AM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

@Zabe do you think you can pick this up? Thanks!

yup

Thanks!

Change #1178894 had a related patch set uploaded (by Zabe; author: Zabe):

[mediawiki/core@master] Add new rc_name_source_patrolled_timestamp index to recentchanges

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

gerritbot added a project: Patch-For-Review.Aug 14 2025, 3:31 PM

• Scardenasmolinar moved this task from Inbox to Radar / Tracking on the Moderator-Tools-Team board.Aug 14 2025, 6:17 PM

Change #1178894 merged by jenkins-bot:

[mediawiki/core@master] Add new rc_name_source_patrolled_timestamp index to recentchanges

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

ReleaseTaggerBot added a project: MW-1.45-notes (1.45.0-wmf.15; 2025-08-19).Aug 15 2025, 12:00 PM

Maintenance_bot removed a project: Patch-For-Review.Aug 15 2025, 12:30 PM

Zabe closed this task as Resolved.Aug 15 2025, 1:02 PM

Ladsgroup removed a subtask: T402010: Add new rc_name_source_patrolled_timestamp index to recentchanges table in wmf production.Aug 15 2025, 1:06 PM

Zabe added a project: DBA.Oct 14 2025, 7:14 PM

Zabe moved this task from Triage to Done on the DBA board.