MongoDB 無法排序：Sort operation used more than the maximum 33554

db.Log.find().sort({CreateTime: -1})

Error: error: {
        "ok" : 0,
        "errmsg" : "Executor error during find command: OperationFailed: Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit.",
        "code" : 96,
        "codeName" : "OperationFailed"
}

發生原因

解決方案

建立索引

db.Log.createIndex({"CreateTime":-1})

db.Log.getIndexes()

增加排序可用的記憶體空間

db.adminCommand({setParameter:1,internalQueryExecMaxBlockingSortBytes:335544320})

結論

參考資料

• Sort operation used more than the maximum 33554432 bytes of RAM
• mongo添加索引以及解决Sort operation used more than the maximum 33554432 bytes of RAM