MongoDB: How to log all queries to log file on Windows

Question

This Questions could not help me: MongoDB logging all queries

Here is my configuration file:

dbpath  = C:\mongodb\data
logpath = C:\mongodb\mongo.log
diaglog = 3                      
profile = 2
slowms  = 1

but my log file contains no queries. What I'm doing wrong?

P.S: I'm using mongodb version v3.2.3

Saleem · Accepted Answer · 2016-03-13 16:45:26Z

1

You have two options to increase your log verbosity.

Increase your log verbosity in configuration file. systemLog.component.query.verbosity = 4 see systemLog.component.query.verbosity documentation
db.setLogLevel(...) see setLogLevel documentation.

your final config file should look like

storage:
   dbPath: "C:\mongodb\data"

systemLog:
   destination: file
   path: "C:\mongodb\mongo.log"
   component:
       query:
           verbosity: 2

operationProfiling:
    slowOpThresholdMs: 100
    mode: slowOp

edited Mar 13, 2016 at 16:45

answered Mar 13, 2016 at 16:10

Saleem

9,0582 gold badges22 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

devops Over a year ago

ok got: unrecognised option 'systemLog.component.query.verbosity'

souldzin Over a year ago

@dit what version of mongo are you running?

souldzin Over a year ago

@dit try increasing the verbosity with the sytnax used here (docs.mongodb.org/v3.0/reference/configuration-options/…)

Harry · Accepted Answer · 2021-06-29 20:20:49Z

0

Connect from the mongo shell and run: db.setLogLevel(2,"query")

answered Jun 29, 2021 at 20:20

Harry

864 bronze badges

Collectives™ on Stack Overflow

MongoDB: How to log all queries to log file on Windows

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related