Details
-
Improvement
-
Resolution: Incomplete
-
Major - P3
-
None
-
None
-
None
-
Storage Execution
Description
MongoDB currently configures the WiredTiger memory_page_max to be 10MB for all collections. That setting tells WiredTiger how much memory to accumulate in a page before splitting or reconciling it.
There is a performance trade off for choosing different sizes, but 10MB does not work very well when MongoDB users insert documents that are larger than 5MB.
We should create several different workloads that are likely to benefit from different settings, and use those workloads to decide if the current default is the best value. The tests should be run on both fast and slow I/O subsystems.