CODEWITHSUNDEEP
mongodb
Andrew Jones
Andrew Jones

Reputation: 1382

Building Multiple Indexes at Once

I have a need to build five indexes in a large MongoDB collection. I'm familiar with the ensureIndex operation, but I do not know of a way to create all five of the indexes with a single command. Is this batch index creation possible in MongoDB?

Upvotes: 13

Views: 10827

Answers (4)

Kevin Smith
Kevin Smith

Reputation: 14436

This is pretty simple within the shell, there is a extention to the collection of createIndexes and you just pass in the keys you wish to create indexes on.

db.test.createIndexes([
        { "a" : 1 },
        { "b" : 1 },
        { "c" : 1 },
        { "d" : 1 },
        { "e" : 1 }
    ]);

This will then give us the following

> db.test.getIndexes()
[
        {
                "v" : 2,
                "key" : {
                        "_id" : 1
                },
                "name" : "_id_",
                "ns" : "test.test"
        },
        {
                "v" : 2,
                "key" : {
                        "a" : 1
                },
                "name" : "a_1",
                "ns" : "test.test"
        },
        {
                "v" : 2,
                "key" : {
                        "b" : 1
                },
                "name" : "b_1",
                "ns" : "test.test"
        },
        {
                "v" : 2,
                "key" : {
                        "c" : 1
                },
                "name" : "c_1",
                "ns" : "test.test"
        },
        {
                "v" : 2,
                "key" : {
                        "d" : 1
                },
                "name" : "d_1",
                "ns" : "test.test"
        },
        {
                "v" : 2,
                "key" : {
                        "e" : 1
                },
                "name" : "e_1",
                "ns" : "test.test"
        }
]
>

Upvotes: 13

Oleg Gritsak
Oleg Gritsak

Reputation: 622

You are wrong, Mongo has createIndexes command since 2.6 (released before 2014)

https://docs.mongodb.com/v3.0/reference/command/createIndexes/

Documentation says, that it requires one pass through collection, so it should be approximately 5 times faster.

Upvotes: 3

Konstantin Bodnia
Konstantin Bodnia

Reputation: 1513

As for now there is no solution for that.

Background will prevent the database from locking and will allow to perform other operations. But to run those operations you will have to open new mongo shell or run them asynchronously in the language of your choice (like js).

But if you need a strong consistency and don't need background index building... you probably will have to wait for a MongoDB native solution to come.

Upvotes: 0

Himanshu Matta
Himanshu Matta

Reputation: 73

I think this is not possible using single command, but you can create your own script which'll perform same. If your collection size is large then I suggest you to build indexes separately with background true to reduce chances of any problem of locking.

db.collection.ensureIndex( { a: 1 }, { background: true } )

Upvotes: -2

Related Questions