Why Memory and storage engine basics (WiredTiger) in MongoDB? - Purpose & Use Cases

The Big Idea

What if your database could find any piece of data instantly, no matter how big it grows?

The Scenario

Imagine you have a huge collection of books scattered all over your room. You want to find a specific book quickly, but you have no shelves or system to organize them. You try to remember where you put each book, but it's confusing and slow.

The Problem

Without a good system, searching for a book takes forever. You might lose books or mix them up. Writing notes about where each book is gets messy and mistakes happen easily. This wastes your time and energy.

The Solution

WiredTiger acts like a smart bookshelf and librarian combined. It organizes data efficiently in memory and on disk, so finding and saving information is fast and reliable. It handles the hard work of managing storage so you don't have to.

Before vs After

✗ Before

Store data in simple files without indexing or caching.

✓ After

Use WiredTiger engine to manage data with caching, compression, and indexing.

What It Enables

It lets your database quickly access and store huge amounts of data without slowing down or losing information.

Real Life Example

Think of an online store with thousands of products. WiredTiger helps the store quickly show product details and update stock without delays, even when many people shop at once.

Key Takeaways

Manual data handling is slow and error-prone.

WiredTiger organizes data efficiently in memory and disk.

This makes databases faster, reliable, and scalable.

Practice

1. What is the default storage engine used by MongoDB that balances speed and storage?

easy

A. WiredTiger

B. MMAPv1

C. InMemory

D. RocksDB

Solution

1. Step 1: Recall MongoDB default engine

   MongoDB uses WiredTiger as its default storage engine since version 3.2 for better performance and compression.

2. Step 2: Compare options

   MMAPv1 is older, InMemory is for volatile data, RocksDB is not default in MongoDB.

3. Final Answer:

   WiredTiger -> Option A

4. Quick Check:

   Default engine = WiredTiger [OK]

Hint: Default MongoDB engine is WiredTiger [OK]

Common Mistakes:

• Confusing MMAPv1 as default
• Thinking InMemory is default
• Assuming RocksDB is default

2. Which configuration file setting correctly specifies WiredTiger as the storage engine in mongod.conf?

easy

A. storage:
engine: wiredtiger

B. storage:
engine: WT

C. storage:
engine: wiredTiger

D. storage:
engine: WiredTiger

Solution

1. Step 1: Check correct case for engine name

   The engine name is case-sensitive and must be 'wiredTiger' with lowercase 'w' and capital 'T'.

2. Step 2: Validate YAML syntax

   storage: engine: WT uses unrecognized abbreviation; C uses all lowercase; D uses incorrect capitalization.

3. Final Answer:

   storage: engine: wiredTiger -> Option C

4. Quick Check:

   Correct engine name is wiredTiger [OK]

Hint: Use exact 'wiredTiger' (lowercase w, capital T) in config [OK]

Common Mistakes:

• Using all lowercase 'wiredtiger'
• Using 'WiredTiger' with capital W
• Using abbreviations like 'WT'

3. Given this mongod.conf snippet:

storage:
  engine: WiredTiger
  wiredTiger:
    engineConfig:
      cacheSizeGB: 2

What does the cacheSizeGB setting control?

medium

A. The disk space allocated for WiredTiger files

B. The amount of RAM WiredTiger uses for caching data

C. The number of CPU cores WiredTiger uses

D. The network bandwidth limit for WiredTiger

Solution

1. Step 1: Understand cacheSizeGB meaning

   cacheSizeGB sets how much RAM WiredTiger uses to cache data in memory for faster access.

2. Step 2: Eliminate other options

   It does not control disk space, CPU cores, or network bandwidth.

3. Final Answer:

   The amount of RAM WiredTiger uses for caching data -> Option B

4. Quick Check:

   cacheSizeGB = RAM cache size [OK]

Hint: cacheSizeGB sets RAM cache size for WiredTiger [OK]

Common Mistakes:

• Thinking it controls disk space
• Confusing with CPU or network settings
• Ignoring memory tuning importance

4. You set cacheSizeGB: 0.5 in mongod.conf but MongoDB starts with poor performance. What is the likely cause?

medium

A. cacheSizeGB must be at least 1 GB

B. cacheSizeGB cannot be a decimal value

C. cacheSizeGB must be set under storage.engine directly

D. cacheSizeGB is ignored and does not affect startup

Solution

1. Step 1: Check WiredTiger cache size limits

   WiredTiger performs poorly if cacheSizeGB is less than 1 GB.

2. Step 2: Validate config placement and value type

   Decimal values are allowed; placement under wiredTiger.engineConfig is correct; it is not ignored.

3. Final Answer:

   cacheSizeGB must be at least 1 GB -> Option A

4. Quick Check:

   Minimum cacheSizeGB = 1 GB [OK]

Hint: cacheSizeGB minimum is 1 GB for good performance [OK]

Common Mistakes:

• Using decimal values thinking they are invalid
• Placing cacheSizeGB under wrong config section
• Assuming cacheSizeGB is optional for startup

5. You want to optimize MongoDB performance on a server with 16 GB RAM. Which cacheSizeGB setting is best for WiredTiger, considering MongoDB and OS need memory?

hard

A. Set cacheSizeGB to 14 to maximize cache

B. Set cacheSizeGB to 16 to use all RAM for cache

C. Set cacheSizeGB to 2 because more cache slows down MongoDB

D. Set cacheSizeGB to 8 to leave memory for OS and other processes

Solution

1. Step 1: Understand memory needs

   MongoDB needs memory for cache and other operations; OS and other apps also need RAM.

2. Step 2: Choose balanced cache size

   Setting cacheSizeGB to about half or slightly more (8 GB) leaves enough RAM for OS and avoids swapping.

3. Step 3: Evaluate other options

   14 or 16 GB risks OS starvation; 2 GB is too low for good performance.

4. Final Answer:

   Set cacheSizeGB to 8 to leave memory for OS and other processes -> Option D

5. Quick Check:

   Balance cache and OS memory = 8 GB [OK]

Hint: Use about half RAM for cache to keep system stable [OK]

Common Mistakes:

• Assigning all RAM to cache causing OS issues
• Setting too low cacheSizeGB hurting performance
• Ignoring OS memory needs