Examining MongoDB Performance

Mongo is very good at providing information on itself -- such as connections, counters for inserts, available connections, etc. There statistics are available through the admin database using the Mongo command line interface.

Execute the command line interface by running the mongo command at the operating system command line:

mongo

Select the admin database:

use admin

Display the server status:

db.serverStatus()

You should see information like this:

{
Â Â Â Â Â Â Â  "version" : "1.6.2",
Â Â Â Â Â Â Â  "uptime" : 445492,
Â Â Â Â Â Â Â  "uptimeEstimate" : 171705,
Â Â Â Â Â Â Â  "localTime" : "Sun Nov 14 2010 00:23:45 GMT-0800 (Pacific Standard Time)",
Â Â Â Â Â Â Â  "globalLock" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "totalTime" : 445491426327,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "lockTime" : 870000,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "ratio" : 0.0000019528995365253154,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "currentQueue" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "total" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "readers" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "writers" : 0
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  }
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "mem" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "bits" : 32,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "resident" : 2,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "virtual" : 1295,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "supported" : true,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "mapped" : 1264
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "connections" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "current" : 1,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "available" : 19999
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "extra_info" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "note" : "fields vary by platform"
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "indexCounters" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "note" : "not supported on this platform"
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "backgroundFlushing" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "flushes" : 2894,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "total_ms" : 1689793,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "average_ms" : 583.8953006219765,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "last_ms" : 2,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "last_finished" : "Sun Nov 14 2010 00:23:34 GMT-0800 (Pacific Standard Time)"
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "cursros" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "totalOpen" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "clientCursors_size" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "timedOut" : 0
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "opcounters" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "insert" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "query" : 3,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "update" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "delete" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "getmore" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "command" : 5
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "asserts" : {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "regular" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "warning" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "msg" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "user" : 0,
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â  "rollovers" : 0
Â Â Â Â Â Â Â  },
Â Â Â Â Â Â Â  "ok" : 1
}

You can watch many of these values to see the performance characteristics of the server.

Joomla Jumpstart

Examining MongoDB Performance

Main Menu

Google AdSense