Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Performance Stats
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  6 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Rodrigo  
View profile  
 More options Aug 6 2012, 2:41 pm
From: Rodrigo <nascimento...@gmail.com>
Date: Mon, 6 Aug 2012 11:41:10 -0700 (PDT)
Local: Mon, Aug 6 2012 2:41 pm
Subject: Performance Stats

Hi All,

How are you?

This is Rodrigo from NetApp Brazil.

It is my first post here I believe it is a DBA related question.

Reading docs from mongodb.org I understand that if I want to know about I/O
stats about my MongoDB I should look at iostat. It is very important to
understand how many reads/writes are going to disk, etc, etc.

Is there any command  or tool where I can see the working set size?

Thanks,

Rodrigo
NetApp - Enjoy it!


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Stephen Steneker  
View profile  
 More options Aug 7 2012, 3:57 am
From: Stephen Steneker <stephen.stene...@10gen.com>
Date: Tue, 7 Aug 2012 00:57:23 -0700 (PDT)
Local: Tues, Aug 7 2012 3:57 am
Subject: Re: Performance Stats

> It is my first post here I believe it is a DBA related question.

> Reading docs from mongodb.org I understand that if I want to know about
> I/O stats about my MongoDB I should look at iostat. It is very important to
> understand how many reads/writes are going to disk, etc, etc.

> Is there any command  or tool where I can see the working set size?

Hi Rodrigo,

There is a wiki page with some information on checking server usage and
estimating working set size:
 http://www.mongodb.org/display/DOCS/Checking+Server+Memory+Usage#Chec...

It looks like you may have already come across the Monitoring+Diagnostics
info:
 http://www.mongodb.org/display/DOCS/Monitoring+and+Diagnostics

To understand your typical working set and server performance over time you
should be using monitoring tools such as MMS and/or Munin.

Cheers,
Stephen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rodrigo  
View profile  
 More options Aug 11 2012, 10:57 am
From: Rodrigo <nascimento...@gmail.com>
Date: Sat, 11 Aug 2012 07:57:29 -0700 (PDT)
Local: Sat, Aug 11 2012 10:57 am
Subject: Re: Performance Stats

Sthepen,

How are you?

Thank you for your reply.
Sorry for my newbie questions, it is because I'm trying to find out how a
Enterprise Storage like NetApp can aggregate values to mongodb
implementations. It is very important to me understand how analyze I/O at
MongoDB. I'm wanna be a MongoDB Database Administrator. *:-)*
Is there any way to see which collections are mostly accessed?

Thanks,

Rodrigo
NetApp - Enjoy it!

PS. Sorry for any English mistakes, it is not my native language.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Stephen Steneker  
View profile  
 More options Aug 12 2012, 1:52 am
From: Stephen Steneker <stephen.stene...@10gen.com>
Date: Sat, 11 Aug 2012 22:52:26 -0700 (PDT)
Local: Sun, Aug 12 2012 1:52 am
Subject: Re: Performance Stats

> Sorry for my newbie questions, it is because I'm trying to find out how a
> Enterprise Storage like NetApp can aggregate values to mongodb
> implementations. It is very important to me understand how analyze I/O at
> MongoDB. I'm wanna be a MongoDB Database Administrator. *:-)*
> Is there any way to see which collections are mostly accessed?

Hi Rodrigo,

The previous links I provided should be a good starting point for
monitoring & stats documentation.

A few items which might be of particular interest for you from those pages
are:
 - the `mongostat` utility which provides a snapshot of DB activity
counters similar to
vmstat: http://docs.mongodb.org/manual/reference/mongostat/
 - 10gen's free hosted MongoDB Monitoring Service (MMS) which can provide
helpful insight into statistics over time: https://mms.10gen.com/

MongoDB uses memory-mapped files for disk I/O, so the general performance
metrics on I/O, Ram, etc can be monitored using your normal O/S admin tools.

To see which collections are accessed you can enable query profiling:
   http://www.mongodb.org/display/DOCS/Database+Profiler

You can query the profile data to get some detail on access patterns by
db+collection ("namespace"), but the information is probably more detailed
than what you are after.

There are a few community-contributed tools that can work with the profiler
data and help make recommendations on indexing:
  http://blog.mongolab.com/2012/07/remote-dex/
  http://late.am/post/2011/09/22/professor-a-mongodb-profile-viewer

Profiling uses a capped collection so will keep a limited amount of
history; you can increase the size if needed:

http://www.mongodb.org/display/DOCS/Database+Profiler#DatabaseProfile...

There are some great presentations across many topics in the 10gen
presentation archive: http://www.10gen.com/presentations.

You mentioned you are based in Brazil.  FYI, there is also an upcoming user
group meeting in Său Paulo at the end of the month which will include a few
visiting 10gen team members:
 http://www.meetup.com/SP-MongoDB/

I would suggest you set up a local instance of MongoDB to test with (if you
haven't already!).

Cheers,
Stephen


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Scott Hernandez  
View profile  
 More options Aug 12 2012, 10:51 am
From: Scott Hernandez <scotthernan...@gmail.com>
Date: Sun, 12 Aug 2012 07:51:49 -0700
Local: Sun, Aug 12 2012 10:51 am
Subject: Re: [mongodb-user] Re: Performance Stats
In particular, mongotop will show the currently accessed collections
listed by most active at the top:
http://docs.mongodb.org/manual/reference/mongotop/


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Rodrigo  
View profile  
 More options Aug 13 2012, 9:17 am
From: Rodrigo <nascimento...@gmail.com>
Date: Mon, 13 Aug 2012 06:17:02 -0700 (PDT)
Local: Mon, Aug 13 2012 9:17 am
Subject: Re: Performance Stats

Sthepen,

Thank you very much!
Very useful links....

Rodrigo
NetApp -Enjoy it!


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »