MongoDB - Revision history

Piousbox: /* In mongosh (old mongo): */

2026-03-16T19:02:33Z

‎In mongosh (old mongo):

2026-03-16T19:00:44Z

‎In mongosh (old mongo):

2026-03-16T18:59:10Z

‎In mongosh (old mongo):

2026-03-16T18:52:03Z

‎In ruby:

2026-03-16T18:51:46Z

‎view slow queries

2026-03-16T18:50:38Z

‎Performance Tuning

2026-03-16T18:49:44Z

‎add member to cluster

2023-03-10T02:15:46Z

‎create user

2022-03-23T17:24:07Z

‎create user

2022-03-20T15:58:09Z

@@ Line 103: / Line 103: @@
 (no need to restart mongo):
    db.setProfilingLevel(1, { slowms: 100 })
    db.system.profile.find().sort({ ts: -1 }).limit(5)

← Older revision		Revision as of 19:00, 16 March 2026
Line 105:		Line 105:
	db.setProfilingLevel(1, { slowms: 100 })		db.setProfilingLevel(1, { slowms: 100 })
	db.system.profile.find().sort({ ts: -1 }).limit(5)		db.system.profile.find().sort({ ts: -1 }).limit(5)
		+
		+	This means:
		+
		+	* 0 → profiling off
		+	* 1 → log slow queries only (recommended)
		+	* 2 → log all queries (very heavy, avoid in production)

@@ Line 100: / Line 100: @@
 === In mongosh (old mongo): ===
    db.setProfilingLevel(1, { slowms: 100 })
    db.system.profile.find().sort({ ts: -1 }).limit(5)

@@ Line 94: / Line 94: @@
      Rails.logger.debug("Mongo Query: #{event.command}")
    end
 === In mongosh (old mongo): ===

@@ Line 84: / Line 84: @@
 == view slow queries ==
-In ruby:
+=== In ruby: ===
    config.mongoid.logger       = Logger.new(Rails.root.join( 'tmp', 'mongo.log' ))
    config.mongoid.logger.level = Logger::DEBUG
-In mongosh (old mongo):
+Mongoid logging can also show caller location if you enable it:
    db.setProfilingLevel(1, { slowms: 100 })
    db.system.profile.find().sort({ ts: -1 }).limit(5)

← Older revision		Revision as of 18:50, 16 March 2026
Line 81:		Line 81:

	db.lineitems.getIndexes()		db.lineitems.getIndexes()
		+
		+	== view slow queries ==
		+
		+	In ruby:
		+
		+	config.mongoid.logger = Logger.new(Rails.root.join( 'tmp', 'mongo.log' ))
		+	config.mongoid.logger.level = Logger::DEBUG
		+
		+	In mongosh (old mongo):
		+
		+	db.setProfilingLevel(1, { slowms: 100 })
		+	db.system.profile.find().sort({ ts: -1 }).limit(5)

@@ Line 64: / Line 64: @@
   db.setProfilingLevel(1, 10)
   db.getCollection('system.profile').find({})
 == profiling ==

@@ Line 47: / Line 47: @@
+   }
+)
 </pre>

@@ Line 37: / Line 37: @@
 == create user ==
-   user admin;
+   use admin;
 <pre>
 db.createUser(

@@ Line 1: / Line 1: @@
-== Install ==
+= Install =
 From: https://docs.mongodb.com/manual/tutorial/install-mongodb-on-os-x/
@@ Line 56: / Line 56: @@
   db.getCollection('system.profile').find({})
-=== add member to cluster ===
+== add member to cluster ==
   operaeventrsX:PRIMARY> rs.add("10.138.96.89")
   operaeventrsX:PRIMARY> rs.conf()
-=== profiling ===
+== profiling ==
 Profiling. From: https://docs.mongodb.com/manual/reference/method/db.setProfilingLevel/