Indexing in MongoDB?
bth...@gmail.com
I have some questions about Indexing of MongoDB
With a large number of documents ( billions), if RAM can't contains full of index? what happens when we use index in query?
Max Schireson
There is a bunch of doc on indexing at mongodb.org or it may be worh watching a recorded talk online at 10gen.com
Quick responses inline, feel free to ask for more detail if this the docs/video don't answer your questions
On Jul 25, 2012 10:28 PM, "easy_...@yahoo.com" <bth...@gmail.com> wrote:
>
> Hello everybody!!
> I have some questions about Indexing of MongoDB
> I want to know the way Index in MongoDB load into RAM in Cluster and find by index, every shards,
Each shard has its own index that covers the docs in that shard. It is loaded into/out of memory by the os based on usage.
when MongoDB start will have full set index or a part of index?
It has whatever indexes you create. Only _id is automatice.
where Information about index save?
Not sure I understand the question but indexes are updated by the system as data is inserted/updated
> With a large number of documents ( billions), if RAM can't contains full of index?
You might get an index on billions of docs in RAM across a cluster, but at whatever point it gets too big the os will page out based on usage.
what happens when we use index in query?
Hopefully it makes the query much faster. Talks cover this in quite a bit of detail and are available online.
> Thanks so much!!
>
> --
> You received this message because you are subscribed to the Google
> Groups "mongodb-user" group.
> To post to this group, send email to mongod...@googlegroups.com
> To unsubscribe from this group, send email to
> mongodb-user...@googlegroups.com
> See also the IRC channel -- freenode.net#mongodb