<    April 2017    >
Su Mo Tu We Th Fr Sa  
                   1  
 2  3  4  5  6  7  8  
 9 10 11 12 13 14 15  
16 17 18 19 20 21 22  
23 24 25 26 27 28 29  
30
01:02 silenced joined
01:03 Gwayne joined
01:18 Soopaman joined
01:36 orbyt_ joined
01:38 KingGregoryXVIII joined
02:30 svm_invictvs joined
02:54 Soopaman joined
02:54 Soopaman joined
03:00 acrocity left
03:03 NoOutlet joined
03:48 louie_louiie joined
03:54 svm_invictvs joined
04:02 preludedrew joined
04:37 Gwayne joined
04:37 Gwayne joined
04:45 yeitijem joined
05:07 dsardari joined
05:30 Soopaman joined
05:30 lpin joined
05:31 tildes joined
05:52 JohnsonAskot joined
06:15 Necromantic joined
06:28 coudenysj joined
06:30 coudenysj joined
06:49 castlelore joined
06:49 castlelore joined
07:00 jri joined
07:00 _jd joined
07:10 rendar joined
07:10 rendar joined
07:15 Lujeni joined
07:31 Folkol joined
07:42 jri joined
07:42 jri_ joined
07:52 okapi joined
07:55 brk_ joined
08:07 shackra joined
08:22 gfidente joined
08:32 m0ltar left
08:39 _jd joined
08:40 jri joined
08:40 ssarah joined
08:42 jri__ joined
08:52 _MPZ joined
09:15 KingGregoryXVIII joined
09:30 bweston92 joined
09:31 KingGregoryXVIII joined
09:40 kexmex joined
10:02 Liara- joined
10:05 Folkol joined
10:06 megamaced joined
10:12 <ssarah> guys, im trying to copy the indexes from one database to the next. Someone told me to use db.coll.getIndexes() , but this doesn't output the properties of each index (unique and such).
10:12 <ssarah> sorry, it's db.coll.getIndexKeys()
10:13 <ssarah> then i would use db.coll.createIndexes(previous_output)
10:13 <ssarah> i asked this here too http://stackoverflow.com/questions/43150231/mongodb-how-to-copy-index-definitions-from-one-collection-to-another
10:18 rideh joined
10:18 <Derick> getindexes shows all the properties
10:20 <Derick> ssarah: I think you have to write a little script to post-process the output of getIndexes()
10:29 <ssarah> Derick, yeh, thats what i was trying to avoid :)
10:29 jwd joined
10:41 Folkol joined
10:45 techwave61 joined
10:49 pagios left
11:01 kexmex joined
11:08 klics joined
11:34 Folkol joined
11:38 Liara- joined
11:47 okapi joined
11:49 re1 joined
12:23 ogurk joined
12:40 dump joined
12:44 StephenLynx joined
12:45 Silenced joined
13:04 Lujeni joined
13:09 edrocks joined
13:18 Silenced joined
13:21 ikus060 joined
13:22 <ikus060> Hello, I'm having trouble with a mongo instance. The database size is less then 1GB, but the memory usage of the process is 15GiB. Any tips for me to check where is this memory using comming from ?
13:26 jr3 joined
13:35 basiclaser joined
13:39 DroidBurgundy joined
13:43 soosfarm joined
13:59 KingGregoryXVIII joined
14:00 geoffb joined
14:05 Folkol joined
14:07 culthero joined
14:30 <ikus060> It seams all the memory is consumed by the cache, but I resident memory. Any command to force mongo to release all the memory ?
14:35 orbyt_ joined
14:48 Guest83 joined
14:50 silenced joined
14:52 gentunian joined
14:56 edrocks joined
14:59 KingGregoryXVIII joined
15:05 silenced joined
15:10 yopp- left
15:10 yopp joined
15:11 okapi joined
15:17 AvianFlu joined
15:25 Soopaman joined
15:33 DroidBurgundy joined
15:35 DroidBurgundy joined
15:37 <yopp> Hey. I'm having troubles with zone ranges.
15:38 <yopp> I have a shard key: `{a: <Int64>, b: <Date>}`. I would like to zone this shard by the `b` key. Docs are saying this is done by specifying MinKey..MaxKey range on be, like this:
15:38 <yopp> cold: {a: MinKey, b: MinKey}, {a: MinKey, b: ISODate("2017-01-01")}
15:38 <yopp> hot: {a: MinKey, b: ISODate("2017-01-01")}, {a: MinKey, b: MaxKey}
15:38 <yopp> But I'm getting `overlapping with existing` error when I'm adding the `hot` tag.
15:50 svm_invictvs joined
15:50 orbyt_ joined
15:56 <yopp> Um. Just checked the example in the docs, it didn't work either
16:05 artok joined
16:10 KingGregoryXVIII joined
16:12 adamsrog joined
16:13 tildes joined
16:13 artok joined
16:16 edrocks joined
16:21 DroidBurgundy joined
16:22 orbyt_ joined
16:22 sz0 joined
16:35 InfoTest joined
16:39 svm_invictvs joined
16:41 DroidBur_ joined
16:47 mdorenka joined
16:49 kexmex joined
16:54 mdorenka joined
17:06 basiclaser joined
17:19 KingGregoryXVIII joined
17:20 dexteruk joined
17:25 point joined
17:26 <dexteruk> Hi Everyone
17:27 dexteruk joined
17:28 tildes joined
17:30 <dexteruk> Hi
17:36 DroidBurgundy joined
17:36 <Derick> hi
17:37 <dexteruk> Im having a problem with mongodb, it only returns me 100 records when i do a aggregation
17:37 <dexteruk> I need it to return all records as its being used in a live search
17:37 <dexteruk> and pagination wont work
17:38 <dexteruk> i have changed the limit to 1000 and it returns 100 records
17:38 <dexteruk> if i set the limit to 50 it returns 50
17:39 <dexteruk> the only way is to get the next group using skip
17:39 <dexteruk> so how do i tell mongodb to return 1000 records not 100
17:41 Soopaman joined
17:41 okapi joined
17:43 tildes_ joined
17:45 <dexteruk> Anyone have any ideas?
17:50 <dexteruk> ??
17:51 SkyRocknRoll joined
17:52 Soopaman joined
17:53 <Derick> dexteruk: there is no reason why it shouldn't return more than 100 - which driver and mongodb version?
17:53 brk_ joined
17:55 <dexteruk> 3.4.2
17:56 <dexteruk> so, its probably the driver im using then
17:56 <dexteruk> Im using mango (non-blocking) with mojolicious
17:57 <Derick> i haven't heard of either of these - sorry
17:58 <dexteruk> so by default mongo will return all records
17:58 <dexteruk> unless you specify the limit
17:58 <Derick> yeah - I think the only exception is the (deprecated) $geoNear query
18:06 okapi joined
18:14 synchroack_ joined
18:14 Sasazuka_ joined
18:27 orbyt_ joined
18:41 Soopaman joined
18:42 kexmex joined
18:49 edrocks joined
18:58 artok joined
19:16 dsardari joined
19:29 edrocks joined
19:33 blizzow joined
19:35 Goopyo joined
19:41 rendar joined
19:43 okapi_ joined
19:47 <Bodenhaltung> How i get this work in PHP? Calculate a offset for timezone: https://gist.github.com/Bodenhaltung/34fb39dc458e1b81e15734866f8683a9
19:48 <Derick> :)
19:48 <Derick> what is the thing you need to calculate?
19:48 <Derick> the 2 * 60 * 60000 ?
19:49 <Derick> you can do: $dtz = new DateTimeZone( "Europe/London" ); echo $dtz->getOffset(new DateTime());
19:49 <Derick> to get the current offset
19:50 <Derick> and then do * 1000 to get milliseconds
19:51 <Derick> Bodenhaltung: also, I hope to get a design spec approved today, to this natively in MongoDB
19:52 artok joined
19:58 <Bodenhaltung> Derick: I need to aggregate dates in my timezone (GMT +2:00)
19:59 <Derick> use Europe/yourcity instead of Europe/London then
19:59 <Derick> see the list at http://php.net/manual/en/timezones.europe.php
20:00 <Bodenhaltung> This works for find but not for aggregate :(
20:01 <Derick> have to go now ...
20:01 <Bodenhaltung> ok :)
20:02 tildes joined
20:04 thewebsurfer joined
20:06 tws joined
20:07 Necromantic joined
20:09 orbyt_ joined
20:12 silenced joined
20:12 Sasazuka joined
20:13 tildes joined
20:22 jscatala joined
20:32 <jscatala> hello! i have a project with mongo and pymongo. i have a document with a certain structure. x with an array y(which is also a collection), which contains an array z(another collection), that has a boolean field f . There is a way that i can filter an get the ids by certain condition on f and retreive all the ids?
20:33 timg__ joined
21:00 Soopaman joined
21:26 StephenLynx joined
21:26 KingGregoryXVIII joined
21:36 joren_ left
22:00 kexmex joined
22:05 KingGregoryXVIII joined
22:06 farchanjo joined
22:34 KingGregoryXVIII joined
22:42 sterns joined
22:55 Necromantic joined
23:10 tambu joined
23:19 flavoredpizza joined
23:25 re1 joined
23:29 Muchoz joined
23:44 Necro|senseless joined
23:54 compeman_ joined