[SERVER-47407] Avoid WriteUnitOfWork in index build collection scan loop Created: 08/Apr/20  Updated: 29/Oct/23  Resolved: 09/Apr/20

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 4.2.6, 4.4.0-rc1, 4.7.0

Type: Improvement Priority: Major - P3
Reporter: Louis Williams Assignee: Louis Williams
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Related
related to SERVER-44577 Ensure WiredTiger cursors have starte... Closed
Backwards Compatibility: Fully Compatible
Backport Requested:
v4.4
Sprint: Execution Team 2020-04-20
Participants:
Linked BF Score: 0

 Description   

This WUOW is not necessary for hybrid index builds because we insert all keys into the external sorter, which is not part of the storage engine.

We could improve index build performance by not having to open and close a storage transaction every iteration.

This fixes a perf regression introduced by SERVER-44577.



 Comments   
Comment by Githook User [ 16/Apr/20 ]

Author:

{'name': 'Louis Williams', 'email': 'louis.williams@mongodb.com', 'username': 'louiswilliams'}

Message: SERVER-44577 Ensure WiredTiger RecordStore and SortedDataInterface cursors have started a transaction before reading data

(cherry picked from commit 34c8bef2ebbe355aef0439a5b85313db1c2f242d)
(cherry picked from commit d71b8cbccdd8bb2cf547989c630229d4c73b2856)

SERVER-44577 Add uses_prepare_transaction tag to test

(cherry picked from commit 4e23322e27b6372e7c747a68a3f657f16211b540)
(cherry picked from commit 15281acee990afa8bf4a67afaf7ce9880e444391)

SERVER-47407 Avoid using WriteUnitOfWork in index build collection scan loop

(cherry picked from commit e9379fcee79456d3795b598ccad91a0694007d0e)
(cherry picked from commit 61c58c415c5f0ec2b8948f54b95b0ec48659b6a2)
Branch: v4.2
https://github.com/mongodb/mongo/commit/1085f4b003369973a545c3fc527689fdcb940c55

Comment by Githook User [ 10/Apr/20 ]

Author:

{'name': 'Louis Williams', 'email': 'louis.williams@mongodb.com', 'username': 'louiswilliams'}

Message: SERVER-47407 Avoid using WriteUnitOfWork in index build collection scan loop

(cherry picked from commit e9379fcee79456d3795b598ccad91a0694007d0e)
Branch: v4.4
https://github.com/mongodb/mongo/commit/61c58c415c5f0ec2b8948f54b95b0ec48659b6a2

Comment by Githook User [ 09/Apr/20 ]

Author:

{'name': 'Louis Williams', 'email': 'louis.williams@mongodb.com', 'username': 'louiswilliams'}

Message: SERVER-47407 Avoid using WriteUnitOfWork in index build collection scan loop
Branch: master
https://github.com/mongodb/mongo/commit/e9379fcee79456d3795b598ccad91a0694007d0e

Generated at Thu Feb 08 05:14:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.