As suggested on bug 65246 comment 5, please create the index.
Wikis:
all wikis
Tables:
watchlist
Change needed:
CREATE INDEX /*i*/wl_user_notificationtimestamp ON /*_*/watchlist (wl_user, wl_notificationtimestamp);
Gerrit change:
https://gerrit.wikimedia.org/r/#/c/137149/
Version: wmf-deployment
Severity: normal
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Declined | Feature | None | T66321 Personal tools are too crowded (tracking) | ||
| Declined | None | T46448 Consolidate personal portlet links into collapsed control or dropdown (tracking) | |||
| Resolved | Anomie | T67246 unread count for watchlist changes is not available via API | |||
| Invalid | None | T51188 [DO NOT USE] Schema changes for Wikimedia wikis (tracking) [superseded by #Blocked-on-schema-change] | |||
| Resolved | • Springle | T68089 Add index wl_user_notificationtimestamp to table watchlist |