After-Adding-Index Write Performance on MongoDB 2.6.7

[data...@gmail.com]

Hi All,

I am using mongodb 2.6.7 on sharded cluster. I am using it for write-intensive purpose. However, some use cases need secondary indexes.

My questions is. How much write performance would be impacted if I add secondary indexes on mongodb 2.6.7?

Answer of this question might be practical (based on your exp) or theoritical (esp who also involved in mongodb development).

I have done some research on this matter, some article says that (old, 2011 & 2012) version of mongodb showed poor performance after indexes are added. Is it still the case? Please see reference below.

http://shekhargulati.com/2011/12/03/how-mongodb-writeread-speed-varies-with-or-without-index-on-a-field/

http://grokbase.com/t/gg/mongodb-user/1258qk0ymw/why-the-performance-of-insert-update-becomes-so-bad-when-adding-an-index

Thank you so much!

[Asya Kamsky]

No one will be able to tell you exactly, because it depends on multiple factors.

Will adding this index take your MongoDB RAM needs beyond what it has
available? If that's the case, expect a huge drop in performance
overall.

If there is sufficient RAM for this index, and the write throughput of
the current setup is *not* at the max, it's possible that you will see
barely any change in performance.

There you go - two extremely different scenarios give you the full
range of possible outputs.

Asya

> --
> You received this message because you are subscribed to the Google Groups
> "mongodb-user"
> group.
>
> For other MongoDB technical support options, see:
> http://www.mongodb.org/about/support/.
> ---
> You received this message because you are subscribed to the Google Groups
> "mongodb-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to mongodb-user...@googlegroups.com.
> To post to this group, send email to mongod...@googlegroups.com.
> Visit this group at http://groups.google.com/group/mongodb-user.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/mongodb-user/db0829db-7798-41fb-9ed5-66939ba361a0%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.