Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Jira Legacy
serverJIRA (openedx.atlassian.net)
serverId13fd1930-5608-3aac-a5dd-21b934d3a4b4
keyDEVOPS-3170

Remove these:

comment_thread_id_1

...

delete_spam_1

Modify these:

 

Add these:

Remove _type_1_commentable_id_1_context_1_pinned_-1_created_at_-1

Code Block
{
        "v" : 1,
        "key" : {
            "_type" : 1,
            "commentable_id" : 1,
            "context" : 1,
            "pinned" : -1,
            "created_at" : -1
        },
        "name" : "_type_1_commentable_id_1_context_1_pinned_-1_created_at_-1",
        "ns" : "comments-prod.contents",
        "background" : true
    },

and re add as,

Code Block
db.contents.ensureIndex({"_type" : -1,  "course_id":1, "commentable_id":1, "context":1, "pinned":-1, "created_at":-1}, {"background":true})

Add these:

Code Block
db.contents.ensureIndex({"_type":-1, "course_id":1, "endorsed":-1, "pinned":-1, "last_activity_at" : -1, "created_at": -1}, {"background":true})
Code Block
db.contents.ensureIndex({"_type" : -1, "course_id" : 1, "pinnedendorsed" : -1, "endorsedpinned": -1, "votes.point" : -1, "created_at": -1}, {"background":true})
Code Block
db.contents.ensureIndex({"_type" : -1, "course_id" : 1, "pinnedendorsed" : -1, "endorsedpinned": -1, "comment_count" : -1, "created_at": -1}, {"background":true})