[SERVER-63087] MongoDB slows down when building an index with seven keys Created: 28/Jan/22  Updated: 31/Jan/22  Resolved: 31/Jan/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Vladimir Beliakov Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-63095 Operations slow down during index build Closed
Operating System: ALL
Participants:

 Description   

We have a collection with about 750k document (size - ~430 MB, storage size - ~170 MB).

When we tried to build an index with seven keys on that collection, the MongoDB server got very slow for the index build time. The queries and update operations got slowed down during the time the index was built.

 

We first encountered this problem after upgrading MongoDB on our servers up to 4.0.12 and was hoping that the new optimized build process.

While being on MongoDB 4.0.12, we would restart one of the secondary replicas and make that replica the primary one. That would completely resolve this issue.

However, after upgrading to 4.2.17 we're still experiencing this problem 



 Comments   
Comment by Vladimir Beliakov [ 28/Jan/22 ]

Unfortunately, I can't edit the issue, so I have to create a new one. Please close this one.

Comment by Vladimir Beliakov [ 28/Jan/22 ]

I accidentally pressed Enter and the issue was created. Going to add more information.

Generated at Thu Feb 08 05:56:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.