mongo queries

mongo

db.getMongo().setSlaveOk()
 
db.currentOp()
 
db.killOp()

show dbs
show collections
 
db.events.find({event: 'view', date: { '$gte': 1338472800, '$lt': 1341064800 } }).count()


// Stupid query: Change a field type from string to number
db.COLLECTION_NAME.find({FIELD_NAME: {$type:2}}).limit(1000000).forEach( function(x) { 
    x.subject = Number(x.subject); db.events.save(x); 
})