mongodb分页显示错误解决过程

{"timestamp":1584239124980,"status":500,"error":"Internal Server Error","message":"Query failed with error code 96 and error message "Executor error during find command :: caused by :: Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit." on server 192.168.1.135:7315; nested exception is com.mongoDB.MonGoQueryException: Query failed with error code 96 and error message "Executor error during find command :: caused by :: Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit." on server 192.168.1.135:7315","path":"/excel/screenResult"}

公司的mongoDB给设置了3G的内存使用。通过free top 。。。命令还是啥的我不知道，反正跟我说只用到了300m。但是还是出了这个500错误。

通过异常信息很清楚看出，排序部分内存有32m的限制，所以3G根本没用上，取消这个排序限制就ok了。