1

I'm currently creating an index on a mongo database and so far it has taken about 52 hours. I've worked with large(r) Mongo databases before but creating an index has never taken this long. My collection has 1 billion rows, and I'm creating the index on a single string field which always has a length of 12.

Should I just leave it running, or is it potentially broken and should just be stopped?

Thanks in advance!

  • What is the MongoDB Version(x,y,z)? – Md Haidar Ali Khan Dec 24 '19 at 5:59
  • @MdHaidarAliKhan 4.2.1 – Ian Newson Dec 24 '19 at 10:50
  • What is the RAM size? What is mongodb installation type? Single Replica set or sharded cluster? – Mani Dec 29 '19 at 17:49
  • @Mani 24GB. It's a single instance server running on Ubuntu. – Ian Newson Dec 29 '19 at 17:59
1

Index creation will be show in the mongo error logs. You can monitor the progress of the index creation. 52 hours is very slow. Can you post the masked error log here?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.