Comments (21)
Hi Jacob, :)
Of course, I'm always opened to include new graphs. Most of times though I'm not familiarized with the services requested, like this one.
So I'd appreciate if you can provide information of how to collect MongoDB statistics and some description of which values are relevant to include in the graphs, and even how they are related each other. Just to make sure that the final graphs are made properly.
Please, let me know.
Thanks
from monitorix.
I dont know much about Perl, but there are official mongodb-bindings for Perl to connect to a database: http://docs.mongodb.org/ecosystem/drivers/perl/
Nice to have would be the datasize/storageSize of a database or colelction (you can get them via dbStats-command [1] and the collStats-command [2].)
Also, if the user sets the profiling-level of the db to "1", the number of slow-queries per time would be nice to see [3].
The serverStatus-command [4] offers much more information about the database, like connections, number of queries, etc... This would be nice too!
Have a nice day, Oliver
[1] http://docs.mongodb.org/manual/reference/command/dbStats/
[2] http://docs.mongodb.org/manual/reference/command/collStats/
[3] http://docs.mongodb.org/manual/tutorial/manage-the-database-profiler/
[4] http://docs.mongodb.org/manual/reference/command/serverStatus/
from monitorix.
I'll take a look to it.
Thanks!
from monitorix.
Hi Jordi,
Sorry I've been away the past week. Ill talk to our resident MongoDB administrator to see what he would like to see and how he collects data now.
Thanks for giving it a try, the information above looks rather good as well.
Oh! just noticed, you got my name wrong :-) Its actually Jake. Its a common mix up from my email. the J is my first initial with the Amey being the last name.
from monitorix.
Jacob,
Any help from your MongoDB administrator will be also very appreciated!
And yes, you're right, I've misspelled completely your name. Sorry for that.
Now it's fixed. :)
from monitorix.
Sorry, hes currently working on a large project. However. He is attending Mongo world this year (Leaves next week i believe). I'm sure he will have many ideas as to how to gauge and monitor performance on Mongo. Since we use your tool pretty standard in our environment I'm sure he will want to get you something to work with. If you wish, we can close this request right now as it will still be awhile before we really have anything for you. Up to you.
from monitorix.
Jacob,
I understand, no problem at all. We can close this request and resume it when he has something interesting in mind. Perhaps even better discuss it by email directly.
I really appreciate your interest on this.
Thanks.
from monitorix.
Hi,
I've been working on this in the past weeks and this is what I have right now:
The new mongodb.pm
module supports monitoring of unlimited number of MongoDB servers, either locally or remotely.
That module uses the command serverStatus
to gather overall statistics of each MongoDB server. It collects the following information:
- uptime (not plotted in graph, useful?)
- Asserts (the sum of all of them)
- backgroundFlushing
- average_ms
- last_ms
- connections
- current
- totalCreated
- dur (not plotted in graph, useful?)
- commits
- journaledMB
- writeToDataFilesMB
- extra_info (not plotted in graph, useful?)
- heap_usage_bytes
- page_faults
- globalLock (not plotted in graph, useful?)
- globalLock.currentQueue
- globalLock.activeClients
- network
- bytesIn
- bytesOut
- numRequests
- opcounters
- insert
- query
- update
- delete
- getmore
- command
- metrics.document
- deleted
- inserted
- returned
- updated
That module is also able to monitor an unlimited number of databases per each MongoDB server. It uses the command dbStats
to gather statistics of each one. It collects the following information:
- collections
- objects (not plotted in graph, useful?)
- dataSize
- storageSize
- numExtents
- indexes
- fileSize
In the screen shot attached you can see the statistics of a very-low activity local MongoDB server, and the statistics of a database called Test1
. If more databases are monitored they will appear stacked at the end.
Thoughts?
from monitorix.
This is done in 0fdc7f2.
from monitorix.
Hello,
When will a new version that includes this be released?
Thanks!
from monitorix.
I have no specific schedule for every version, so I can't tell you when it will be released.
I'd like to include some new things in the current devel version before releasing it.
from monitorix.
I configured Mongodb graph and when I open the url I am able to see the mongodb tables. However, I see no data in the graphs. Do I need to configure username, password of the db also on monitorix.conf file?
I have installed mongodb and monitorix on the same linux box.
Below the configuration:
list = localhost
max_db = 1
host = 127.0.0.1
db_list =
rigid = 0, 0, 0, 0, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100, 100, 100
from monitorix.
You should specify in the option db_list =
the database name(s) that you want to monitor.
from monitorix.
Yes I have specified it.
I changed it like below and then restarted service but does not work.
mongodb
list = localhost
max_db = 1
<desc
<localhost
host = IP address of the mongo db.. not 127.0.0.1
port = 27017
db_list = dbname
</localhost
</desc
rigid = 0, 0, 0, 0, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100, 100, 100
</mongodb
Where can I specify credentials like username and password to connect to mongodb?
from monitorix.
I have removed the formatting because somehow it does not allow me to post with formatting
from monitorix.
<mongodb>
list = localhost
max_db = 1
<desc>
<localhost>
host = dbIP
port = 27017
db_list = dbname
</localhost>
</desc>
rigid = 0, 0, 0, 0, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100, 100, 100
</mongodb>
from monitorix.
I'm afraid the only options I implemented were host
, port
and db_list
, I'm sorry.
I'll include in my ToDo list to add the options username
and password
, but you should create a new issue for this, and leave this issue closed as it is.
Meanwhile, and as workaround, I think you could hack the port
option like this:
port = "27017 --username <username> --password <secret>"
I hope that helped you.
from monitorix.
<mongodb>
list = localhost
max_db = 1
<desc>
<localhost>
host = dbIP (not 127.0.0.1)
port = "27017 --username=username --password=password"
db_list = dbname
</localhost>
</desc>
rigid = 0, 0, 0, 0, 0, 0, 0, 0
limit = 100, 100, 100, 100, 100, 100, 100, 100
</mongodb>
Updated like this in my conf file.. .. and will check if that works.
Also I will raise another issue for this.
from monitorix.
Updated like this in my conf file.. .. and will check if that works.
OK, just let me know.
Also I will raise another issue for this.
Perfect! 👍
from monitorix.
I went thru all the stats in serverStatus output of MongoDB. I find below also useful in graph if possible:
**globalLock (not plotted in graph, useful?)**
globalLock.currentQueue
globalLock.activeClients
Can I raise separate issue for that?
from monitorix.
Can I raise separate issue for that?
Yes, of course, but please be as much detailed as possible on how to gather this statistic value.
Thanks.
from monitorix.
Related Issues (20)
- nVidia GTX 780 Ti showing -nan% for everything HOT 1
- remove ipv6 (OR ipv4) graphs completely HOT 1
- How data for process can be get as raw? HOT 14
- Errors in monitorix log (expected XX data source readings (got YY) from N) HOT 1
- Mongo 6 does not seem to be supported by Monitorix HOT 8
- Feature : Support for speedtest to monitor internet bandwidth
- Debian 11. HTTP starting only on localhost HOT 2
- Too verbose /var/log/monitorix-httpd - http access log lines should not be added by default, HOT 4
- Interrupt graph not correct display HOT 2
- FS graph not showing some disk HOT 15
- CSS Blocked HOT 13
- PostgreSQL permissions HOT 2
- Processes statistics, memory usage HOT 4
- Poor temporal resolution suddenly (DST issue?) HOT 7
- Wrong voltage unit of the motherboard sensors (lm-sensors) HOT 2
- Server freezes after restarting monitorix HOT 35
- Support hp raid controllers HOT 12
- Monitix reporting seemingly false clock frequency on Raspberry pi 4 HOT 6
- Suggest HTTP built-in server disabled default HOT 22
- Nvidia A2000 not see gpu usage HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from monitorix.