Mongotail, Log all MongoDB queries in a "tail"able way.
mongotail
is a command line tool to outputs any operation from a Mongo database in the standard output. You can see the operations collected by the database profiler from a console, or redirect the result to a file, pipes it with grep
or other command line tool, etc.
The syntax is very similar to mongo
client, and the output, as like tail
command will be the latest 10 lines of logging.
But the more interesting feature (also like tail
) is to see the changes in "real time" with the -f
option, and occasionally filter the result with grep
to find a particular operation.
Usage:
mongotail [db address] [options]
"db address" can be:
foo | foo database on local machine (IPv4 connection) |
192.169.0.5/foo | foo database on 192.168.0.5 machine |
remotehost/foo | foo database on remotehost machine |
192.169.0.5:9999/foo | foo database on 192.168.0.5 machine on port 9999 |
"[::1]:9999/foo" | foo database on ::1 machine on port 9999 (IPv6 connection) |
Optional arguments:
- -u USERNAME, --username USERNAME
username for authentication
- -p PASSWORD, --password PASSWORD
password for authentication. If username is given and password isn't, it's asked from tty.
- -n N, --lines N output the last N lines, instead of the last 10. Use
ALL value to show all lines
-f, --follow output appended data as the log grows -l LEVEL, --level LEVEL Specifies the profiling level, which is either 0 for no profiling, 1 for only slow operations, or 2 for all operations. Or use with 'status' word to show the current level configured. Uses this option once before logging the database -s MS, --slowms MS Sets the threshold in milliseconds for the profile to consider a query or operation to be slow (use with --level 1). Or use with 'status' word to show the current milliseconds configured. -h, --help show this help message and exit --version show program's version number and exit
You have to activate first in the current database the profiler, so MongoDB will capture all the activity in a special document that is read by Mongotail.
You can achieve this with -l, --level
option. For example, if you want to see the logs from MYDATABASE, first you have to execute this:
$ mongotail MYDATABASE -l 2
Then you can see the latest lines of logging with:
$ mongotail MYDATABASE
2015-02-24 19:17:01.194 QUERY [Company] : {"_id": ObjectId("548b164144ae122dc430376b")}
2015-02-24 19:17:01.195 QUERY [User] : {"_id": ObjectId("549048806b5d3db78cf6f654")}
2015-02-24 19:17:01.196 QUERY [Company] : {"_id": ObjectId("548b16df44ae122dc4303771")}
2015-02-24 19:17:10.729 COUNT [User] : {"active": {"$exists": true}, "firstName": {"$regex": "mac"}}
...
NOTE: The level chosen can affect performance. It also can allow the server to write the contents of queries to the log, which might have information security implications for your deployment. Remember to setup your database profiling level to 0
again after debugging your data:
$ mongotail MYDATABASE -l 0
You can install the latest stable version with pip
in your environment with:
$ pip install mongotail
Execute this command with administrator/root privileges.
You have to be installed pip
tool first. In Debian/Ubuntu Linux distribution you can install it with (also with root privileges):
$ apt-get install python-pip python-dev
See INSTALL.rst guide to install from sources.
Project: https://github.com/mrsarm/mongotail
Authors: (2015) Mariano Ruiz <mrsarm@gmail.cm>
License: GPL-3