Running notifications as InnoDB is very slow because we do not have an index on uid.

CommentFileSizeAuthor
#1 notifications-uid-index-1512416-1.patch1.28 KBJoeMcGuire

Comments

JoeMcGuire’s picture

JoeMcGuire commented
Status: Active » Needs review
StatusFileSize
new notifications-uid-index-1512416-1.patch1.28 KB

Patch attached adds an index to the field for new installs and updates.

rjbrown99’s picture

rjbrown99 commented

Similar/duplicate issue to this one?

#1070762: notifications_queue() slow query