3

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!

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

1 Answer 1

Reset to default
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?

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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