[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: |
|
||||||||||||||||||||||||||||||||||||||||||||
| 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: |
| Comment by Githook User [ 15/Jun/21 ] |
|
Author: {'name': 'Yuhong Zhang', 'email': 'danielzhangyh@gmail.com', 'username': 'YuhongZhang98'}Message: |