[DOCS-98] Migrate "Database Profiler" page and include recent changes Created: 05/Jan/12  Updated: 13/Nov/23  Resolved: 12/Dec/12

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: None
Fix Version/s: mongodb-2.2, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

Type: Improvement Priority: Major - P3
Reporter: Uladzimir Mihura Assignee: Bob Grabar
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to DOCS-665 Create Optimization Tutorial Closed
related to DOCS-157 Database Profiling Closed
is related to DOCS-849 Create a Database Profiler Tutorial Closed
is related to DOCS-850 Create reference documentation on the... Closed
Participants:
Days since reply: 11 years, 25 weeks, 6 days ago

 Description   

http://www.mongodb.org/display/DOCS/Database+Profiler

In the doc:

> db.system.profile.find()
{"ts" : "Thu Jan 29 2009 15:19:32 GMT-0500 (EST)" , "info" : "query test.$cmd ntoreturn:1 reslen:66 nscanned:0  <br>query: { profile: 2 }  nreturned:1 bytes:50" , "millis" : 0}
...

In the shell:

> db.system.profile.find()
{ "ts" : ISODate("2012-01-05T15:48:13.735Z"), "op" : "query", "ns" : "test.system.namespaces", "query" : { }, "nscanned" : 21, "nreturned" : 21, "responseLength" : 1068, "millis" : 0, "client" : "127.0.0.1", "user" : "" }
{ "ts" : ISODate("2012-01-05T14:31:35.450Z"), "op" : "command", "ns" : "test.$cmd", "command" : { "create" : "test123", "capped" : null, "size" : null, "max" : null }, "ntoreturn" : 1, "responseLength" : 37, "millis" : 59, "client" : "127.0.0.1", "user" : "" }

Difference in info section and op,ns,command,query



 Comments   
Comment by Daniel Pasette (Inactive) [ 23/Aug/12 ]

Need to document the new fields used in 2.2:

> db.system.profile.find().sort({ts:-1}).limit(1).pretty()
{
	"ts" : ISODate("2012-07-05T18:18:26.445Z"),
	"op" : "query",
	"ns" : "test.system.indexes",
	"query" : {
		"expireAfterSeconds" : {
			"$exists" : true
		}
	},
	"ntoreturn" : 0,
	"ntoskip" : 0,
	"nscanned" : 16,
	"keyUpdates" : 0,
	"numYield" : 0,
	"lockStats" : {
		"timeLockedMicros" : {
			"r" : NumberLong(34),
			"w" : NumberLong(0)
		},
		"timeAcquiringMicros" : {
			"r" : NumberLong(1),
			"w" : NumberLong(2)
		}
	},
	"nreturned" : 0,
	"responseLength" : 20,
	"millis" : 0,
	"client" : "0.0.0.0",
	"user" : ""
}

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