[SERVER-28108] Standalone Mongo Performance Severely Downgraded Created: 24/Feb/17 Updated: 24/Feb/17 Resolved: 24/Feb/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | MMAPv1 |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Question | Priority: | Major - P3 |
| Reporter: | Krystal Flores | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Running in Linux AWS |
||
| Participants: |
| Description |
|
Our performance of our MongoDB Standalone started running extremely slow. It has been running seamlessly for 3 months now. Basically yesterday I noticed a 70% downgrade in the ability to iterate through a cursor. I've increased the RAM on the box to 500GB even though that didn't seem an issue. We know this should be sharded but it is not. Our primary collection:
This machine also is NOT using WiredTiger. There also is TTL index running:
Here are the stats:
I was going to run a mongodump on the collection so that I can remove probably over half of what is in there. The query for the mongodump is using the field "d".. which is the same one the TTL index is using. This is the output from the mongodump. Is this the number of documents dumped? If so it's running as slow as my process was running so this isn't going to help me. Is there any reason a database would just slow down when iterating over a cursor? There is a ton of memory on here.
|
| Comments |
| Comment by Kelsey Schubert [ 24/Feb/17 ] |
|
Hi kflores, Thanks for your report. Please note that SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag. A question like this involving more discussion would be best posted on the mongodb-users group. In addition, I would recommend providing the output of db.currentOp(), which may identify an operation that explains this slowdown. Kind regards, |