[SERVER-13938] Allow TTLMonitor to use existing indexes starting with Date field Created: 14/May/14  Updated: 21/Jul/23  Resolved: 16/Jun/21

Status: Closed
Project: Core Server
Component/s: Storage
Affects Version/s: 2.4.10
Fix Version/s: 5.1.0-rc0

Type: New Feature Priority: Major - P3
Reporter: Alon Horev Assignee: Yuhong Zhang
Resolution: Done Votes: 1
Labels: TTLMonitor, execution_intern, newgrad
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Documented
is documented by DOCS-14569 Investigate changes in SERVER-13938: ... Closed
Duplicate
is duplicated by SERVER-9305 Enabling adding expireAfterSeconds to... Closed
Problem/Incident
causes SERVER-60956 collMod command allows converting ind... Closed
Related
related to SERVER-9305 Enabling adding expireAfterSeconds to... Closed
is related to SERVER-63876 [5.0] Secondary nodes crash when appl... Closed
Backwards Compatibility: Minor Change
Backport Requested:
v5.0
Sprint: Execution Team 2021-03-08, Execution Team 2021-06-14, Execution Team 2021-06-28
Participants:

 Description   

If the composite index starts with the Date field, the TTLMonitor's queries would be as fast and will not require an extra index.

We have lots of time-series data with composite indexes starting with Date, we're forced to create the TTL index although it's used solely by the TTLMonitor.



 Comments   
Comment by Ian Springer [ 21/Jul/23 ]

+1 for 5.0 backport

Comment by Githook User [ 16/Jun/21 ]

Author:

{'name': 'Yuhong Zhang', 'email': 'danielzhangyh@gmail.com', 'username': 'YuhongZhang98'}

Message: SERVER-13938 Enabling adding expireAfterSeconds to convert to a TTL index
Branch: SERVER-34632
https://github.com/mongodb/mongo/commit/2b7d1168d19abc570e00c337ba05e66a98d7fb83

Comment by Githook User [ 15/Jun/21 ]

Author:

{'name': 'Yuhong Zhang', 'email': 'danielzhangyh@gmail.com', 'username': 'YuhongZhang98'}

Message: SERVER-13938 Enabling adding expireAfterSeconds to convert to a TTL index
Branch: master
https://github.com/mongodb/mongo/commit/2b7d1168d19abc570e00c337ba05e66a98d7fb83

Generated at Thu Feb 08 03:33:21 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.