[DOCS-14144] Investigate changes in SERVER-51730: Report histogram data on how long it takes cursors to drain Created: 21/Jan/21  Updated: 13/Nov/23  Resolved: 23/Mar/21

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 5.0.0-rc0, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Jason Price
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
documents SERVER-51730 Report histogram data on how long it ... Closed
Participants:
Days since reply: 2 years, 46 weeks, 1 day ago
Epic Link: DOCSP-9747

 Description   

Description

Downstream Change Summary

Added a new server status metric to count the number of cursors with lifespans between pre-defined lifespan buckets. The buckets are 0s - 1s, 1s - 5s, 5s - 15s, 15s - 30s, 30s - 1m, 1m - 10m, and >= 10m. The ranges exclude the lower number include the upper number (so 1s - 5s means 1s < t <= 5s).

The names of these buckets are:

"cursor.lifespan.lessThan1Second", "cursor.lifespan.lessThan5Seconds", "cursor.lifespan.lessThan15Seconds", "cursor.lifespan.lessThan30Seconds", "cursor.lifespan.lessThan1Minute", "cursor.lifespan.lessThan10Minutes", "cursor.lifespan.greaterThanOrEqual10Minutes",

Description of Linked Ticket

Report histogram data in serverStatus on cursor drain times (i.e. the time from when a cursor is created to when it is exhausted or killed).

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Githook User [ 23/Mar/21 ]

Author:

{'name': 'Jason Price', 'email': 'jason.price@mongodb.com', 'username': 'jason-price-mongodb'}

Message: DOCS-14144-report-histogram-data-on-cursors-drain
Branch: v5.0
https://github.com/mongodb/docs/commit/407d9fb9be1e7321564a36c4426dac3d6fcd31b5

Comment by Jason Price [ 17/Mar/21 ]

Verified presence of new statistics:

MongoDB Enterprise tic:PRIMARY> db.serverStatus()
{
   "host" : "Jasons-MBP:27001",
   "version" : "4.9.0-alpha2-65-g5285621",
   "process" : "mongod",
   ...
 
   "metrics" : {
 
   ...
	"cursor" : {
			"moreThanOneBatch" : NumberLong(1040),
			"timedOut" : NumberLong(0),
			"totalOpened" : NumberLong(1042),
			"lifespan" : {
				"greaterThanOrEqual10Minutes" : NumberLong(0),
				"lessThan10Minutes" : NumberLong(0),
				"lessThan15Seconds" : NumberLong(2),
				"lessThan1Minute" : NumberLong(0),
				"lessThan1Second" : NumberLong(1038),
				"lessThan30Seconds" : NumberLong(0),
				"lessThan5Seconds" : NumberLong(0)
			},
			"open" : {
				"noTimeout" : NumberLong(0),
				"pinned" : NumberLong(2),
				"total" : NumberLong(2)
...
}

Generated at Thu Feb 08 08:09:37 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.