Log file Viewer

[00:05:32] <mhenson> never mind my connundrum, the server finally shut down

[01:24:24] <at133> Hi, I have a simple map reduce function that I would like to sort by date. The mongo docs aren't really clear on it. When I use map_reduce(map, reduce, {:out => {:inline => true, :sort => ["hour", 1]}, :raw => true }) it doesn't change the result at all. Is this the correct usage to pre sort the keys?

[03:25:31] <dstorrs> do mongodump files compress at all?

[03:46:40] <ukd1> is anyone familiar with mongoid for ruby?

[04:47:53] <dstorrs> ukd1: you still here?

[04:48:07] <dstorrs> I am very vaguely familiar with it. What do you need to know?

[04:48:40] <dstorrs> (ping me by name if you respond, as I'm window-flipping a lot)

[05:01:43] <themiddleman> Hello!

[05:05:09] <themiddleman> I am updating some code that atomically updates some properties on objects in a nested array using the $ positional operator. I am updating it to do multiple updates, is this possible with 1 query? Let me get you some code...

[05:12:38] <themiddleman> http://pastie.org/4218758

[05:14:06] <themiddleman> is that kind of update possible?

[07:17:31] <mexlex> hi

[07:17:39] <mexlex> mongo replication sends transactions in bulk?

[07:18:02] <mexlex> ops i mean

[08:58:08] <floydgreen> hi all, can anyone help me with a bugfix for mongoexport? The forum thread is here: https://groups.google.com/forum/?fromgroups#!topic/mongodb-user/ngu9U1lKMfk

[09:13:20] <floydgreen> i'm just building and manually testing my patch now, are there any unit tests for mongoexport?

[10:18:45] <rydgel> Do someone know what this means: http://pastebin.com/S05HVbzv (during a moveChunk)?

[10:56:08] <multiHYP> hi

[10:56:30] <multiHYP> how are passwords in system.users saved?

[10:57:04] <multiHYP> if I want to retrieve it in my app what should do to the hash like content to get the original password?

[11:31:55] <McNulty__> I've got a MapReduce that touches all of the records in a large collection, what sort of impact will it have on other queries being run on that node?

[11:32:03] <McNulty__> Basically how much should I worry about it

[11:33:02] <floydgreen> I've just made a patch to fix a bug in mongoexport and created a pull request on github. Is this the best way to get a patch submitted?

[12:19:41] <Bartzy> Hi

[12:19:52] <Bartzy> Why Mongo refuses to sort on a big collection without an index on the sorted field ?

[12:20:09] <Bartzy> I mean, even if it's sorting only the first 20 (with limit), it still needs to sort through the whole collection to get those 20... isn't it ?

[12:20:19] <Bartzy> So why limiting non-indexed sorts helps anything ?

[16:02:18] <Bartzy> Hey

[16:02:25] <Bartzy> How can I remove a collection?

[16:02:39] <Bartzy> doing db.collection_name.remove() removes all the documents from it

[16:02:47] <Bartzy> but it show collections it still shows, that annoys me ;)

[16:02:50] <Bartzy> How can I remove it completely ?

[16:51:17] <falu> Anyone able to explain why I'm getting a generated _id instead of my own here: db.places.update({'_id': my_id}, {'loc': [lon, lat]}, upsert=True)

[16:53:32] <falu> On the other hand this works: db.places.update({'_id': my_id}, {'_id': my_id, 'loc': [lon, lat]}, upsert=True)

[17:41:31] <Bartzy> How do I run multiple commands on the mongo shell one after the other

[17:41:31] <Bartzy> like

[17:41:41] <Bartzy> db.blah.count(); sleep(10000); db.blah.count() ?

[18:16:45] <Bartzy> I'm doing heavy inserts right now

[18:16:49] <Bartzy> 8669 0 0 0 0 1 0 19.9g 40.1g 9.77g 0 15.2 0 0|0 0|0 3m 1k 2 18:17:08

[18:16:53] <Bartzy> sorry:

[18:17:00] <Bartzy> insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn time

[18:17:01] <Bartzy> 10055 0 0 0 0 1 0 19.9g 40.1g 9.77g 0 17.8 0 0|0 0|0 3m 1k 2 18:17:28

[18:17:08] <Bartzy> What does locked % mean?

[18:17:14] <Bartzy> Does all that mean that the server is capped?

[18:17:18] <Bartzy> It's a 12GB RAM server.

[18:59:47] <toothrot> Bartzy, "locked - percent of time in global write lock"

[18:59:55] <toothrot> oops

[20:10:16] <vsmatck> I really like "notablescan" option. Writing some tests and came across a index I thought I had, but didn't.

[20:37:47] <Zelest> Warning: Mongo::selectCollection() expects exactly 2 parameters, 1 given ..

[20:38:00] <Zelest> http://www.php.net/manual/en/mongodb.selectcollection.php tells me otherwise.. :o

[20:40:41] <Bartzy> Hey

[20:40:45] <Bartzy> Anyone here ?

[20:40:50] <Zelest> o/

[20:40:54] <Bartzy> if I want to sort by some field

[20:40:59] <Bartzy> I have to have index on that field ?

[20:41:23] <Zelest> No, but it's a lot faster.

[20:41:38] <Zelest> Otherwise the sort needs to do a scan on the entire collection.

[20:42:08] <Bartzy> And on 100 million documents, that would be very slow ?

[20:42:26] <Bartzy> so just a single index on the field? Not so compound index that can be used for other queries maybe?

[20:43:02] <Bartzy> I tried to do db.shares.find().sort({timestamp:-1}).limit(50).explain()

[20:43:07] <Bartzy> but this doesn't end too!

[20:43:39] <Bartzy> in MySQL EXPLAIN is immediate, how can I see explain in Mongo fast ?

[21:13:57] <Bartzy> Anyone?

[21:13:58] <Bartzy> :\

[22:51:11] <brillopad> Hi guys

[22:52:08] <brillopad> Looking to move to another type of DB for a project that I'm planning. At the moment, I'm using MySQL and need something that can drag figures out of a database really quickly.

[22:52:42] <brillopad> It's basically a dashboard system that will need to log a few figures against a set of 'agents' every day

[22:53:16] <brillopad> The dashboard needs to calculate some figures for groups of these people on a given date range. Does it sounds like Mongo might be the way to go or am I barking up the wrong tree?

[23:53:01] <vsmatck> The word "drag" indicates you haven't thought about this very much.