Page MenuHomePhabricator

Review real-world query plans and performance for Jade
Closed, DeclinedPublic

Description

The JOINs between Jade tables and MediaWiki recentchanges should be reviewed as we accumulate real data in the tables. There's some potential for bad optimization and full scans, and certain filter conditions will be very sparse.

Do this task once we hit something like 1M rows.

Related Objects

StatusSubtypeAssignedTask
DeclinedNone
Declinedcalbon
InvalidNone
InvalidNone
Resolvedawight
Resolvedawight
Resolvedawight
Resolvedawight
ResolvedHalfak
ResolvedNone
InvalidNone
ResolvedHalfak
Resolvedawight
ResolvedHarej
DuplicateNone
DeclinedNone
Resolvedawight
Resolvedawight
DeclinedNone
ResolvedReedy
ResolvedLadsgroup
ResolvedLadsgroup
Resolvedmmodell
ResolvedNone
ResolvedNone
Resolvedhashar
ResolvedNone
Resolvedawight
DeclinedNone
DuplicateNone
DeclinedNone
DeclinedNone
DeclinedNone
DuplicateNone
DuplicateNone
DuplicateHarej
InvalidNone
DuplicateHalfak
DuplicateNone
InvalidNone
InvalidNone
ResolvedACraze
ResolvedACraze
ResolvedACraze
ResolvedACraze
DeclinedNone
DuplicateACraze
ResolvedHalfak
ResolvedHalfak
ResolvedACraze
ResolvedACraze
ResolvedNone
ResolvedHalfak
ResolvedACraze
ResolvedACraze
Resolvedkevinbazira
ResolvedACraze
ResolvedACraze
ResolvedACraze
ResolvedNone
ResolvedHalfak
DuplicateHalfak
Resolvedkevinbazira
ResolvedACraze
ResolvedACraze
ResolvedACraze
ResolvedHalfak
ResolvedACraze
ResolvedACraze
Resolvedkevinbazira
ResolvedHalfak
ResolvedACraze
ResolvedACraze
DeclinedNone
Resolvedkevinbazira
ResolvedHalfak
DuplicateHalfak
Resolvedkevinbazira
Resolvedkevinbazira

Event Timeline

Marostegui triaged this task as Medium priority.Dec 20 2018, 6:19 PM
Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.
Halfak lowered the priority of this task from Medium to Low.Feb 19 2019, 10:43 PM
Halfak moved this task from Unorganized to Research & analysis on the Machine-Learning-Team board.
LSobanski added a subscriber: LSobanski.

Removing the DBA tag and subscribing myself instead. If there are any specific actions for DBA please re-add us or @mention me.

Aklapper lowered the priority of this task from Low to Lowest.May 23 2021, 10:54 PM
ACraze added a subscriber: ACraze.

Jade is archived, see: T281430: Archive Jade extension