How many documents can a single collection have in MongoDB?

Question

I haven't found any information about this.

How many documents can a single collection have in MongoDB before it is necessary to use sharding?

You can find the answer here. http://stackoverflow.com/questions/9858393/limits-of-number-of-collections-in-databases — Eldho NewAge, Apr 26 '16 at 09:48
@EldhoNewAge That question is about the number of *collections* in MongoDB, not the number of *documents* within a collection. — Uyghur Lives Matter, Apr 27 '16 at 22:29

score 16 · Accepted Answer · edited Aug 13 '19 at 03:58

16

There is no limitation as you can see here:

If you specify a maximum number of documents for a capped collection using the max parameter to create, the limit must be less than 2^32 documents. If you do not specify a maximum number of documents when creating a capped collection, there is no limit on the number of documents.

edited Aug 13 '19 at 03:58

simhumileco

31,877
16
137
115

answered Apr 26 '16 at 13:45

M-A. Fernandes

530
5
13

2

In contrast with @M-A. Fernandes, there is a limitation. But it is not imposed by MongoDB and it's not a fixed number of documents. It may seems very obvious, but correct: the limitations on collection sizes depends on your system capability. How big a collection can be in a single node? – Héctor Valverde Apr 26 '16 at 14:55

score 4 · Answer 2 · edited Jun 20 '20 at 09:12

@M-A.Fernandes has right.

I can only add this information:

Maximum Number of Documents Per Chunk to Migrate

MongoDB cannot move a chunk if the number of documents in the chunk exceeds either 250000 documents or 1.3 times the result of dividing the configured chunk size by the average document size. db.collection.stats() includes the avgObjSize field, which represents the average document size in the collection.

How many documents can a single collection have in MongoDB?

2 Answers2