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-13T16:45:26.520

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 '16 at 16:45

answered Mar 13 '16 at 16:10

Saleem

8,728
2
20
34

ok got: `unrecognised option 'systemLog.component.query.verbosity'` – alex Mar 13 '16 at 16:28
@dit what version of mongo are you running? – souldzin Mar 13 '16 at 16:36
@dit try increasing the verbosity with the sytnax used here (https://docs.mongodb.org/v3.0/reference/configuration-options/#systemlog-options) – souldzin Mar 13 '16 at 16:41

score 0 · Answer 2 · answered Jun 29 '21 at 20:20

0

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

answered Jun 29 '21 at 20:20

Harry

86
4

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

2 Answers2