Create index in MongoDB

Question

I want to create Index in mongodb , but with the classic method

db.OPC_PLANT_DATA.createIndex( { "ITEM_ID" : 1.0,"ITEM_TIMESTAMP" : -1.0 } )

the db get stucked and it takes lot of time , so if I want to do it in Production it will impcat all the work !!

Someone knows how to do it without having any impact on documents insertion ??

Mark Bramnik · Accepted Answer · 2020-06-18 13:02:34Z

1

Mongo Db allowed creation of indices in background. You had to specify background:true option while creating an index.

This was deprecated in version 4.2 of mongo though because they've optimized the index creation process.

Read the relevant documentation chapter

answered Jun 18, 2020 at 13:02

Mark Bramnik

43k5 gold badges67 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AbdelAziz ESSAADI Over a year ago

can you please give me the exactly place os syntaxe where to specify background:true in the query

Mark Bramnik Over a year ago

db.collection.createIndex(<keys_to_create_index>, {'background' : true}) I guess (don't have a working mongo instance to check). Here is a documentation docs.mongodb.com/manual/reference/method/…

Collectives™ on Stack Overflow

Create index in MongoDB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related