<     May 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 _2_6 27  
28 29 30 31
00:08 gentunian joined
00:30 gentunian joined
00:41 lessthan_jake joined
00:42 lessthan_jake joined
00:49 Gwayne joined
00:49 Gwayne joined
00:55 culthero joined
01:12 Sasazuka joined
01:17 svm_invictvs joined
01:25 gentunian joined
01:44 svm_invictvs joined
02:03 svm_invictvs joined
02:04 kanas joined
02:06 svm_invictvs joined
02:47 igniting joined
02:49 culthero joined
02:51 mdorenka joined
03:00 sandstrom joined
03:13 SkyRocknRoll joined
03:44 edrocks joined
04:05 igniting joined
04:54 clouder`grr joined
04:59 lessthan_jake joined
05:20 lpin joined
05:21 culthero joined
05:23 SkyRocknRoll joined
05:25 tildes joined
05:41 igniting joined
06:07 SkyRocknRoll joined
06:14 sjums_ left
06:14 sjums joined
06:15 <clouder`grr> anyone using robomongo know how to suppress output of lines that manipulate variables before the command against the db is run?
06:22 Mia joined
06:22 Mia joined
06:23 gfidente joined
06:23 gfidente joined
06:23 ace- joined
06:42 soosfarm joined
06:49 jri joined
06:56 sz0 joined
07:08 joannac joined
07:08 joannac joined
07:09 shackra joined
07:10 rendar joined
07:10 Lujeni joined
07:22 armyriad joined
07:22 freddy_ joined
07:27 Folkol joined
07:31 sandstrom joined
07:51 freddy__ joined
08:02 Folkol joined
08:12 freddy_ joined
08:13 freddy_ joined
08:19 freddy_ joined
08:20 freddy__ joined
08:24 Jan-_ left
08:25 ams__ joined
08:26 KekSi joined
08:30 freddy_ joined
08:37 KekSi joined
08:39 FatNoLife joined
08:40 klics joined
09:04 okapi joined
09:09 re1 joined
09:28 Folkol joined
09:31 undertuga joined
09:49 edrocks joined
09:55 okapi joined
10:03 goldfish joined
10:07 harry1 joined
10:19 tildes joined
10:32 hendry joined
10:48 kraft joined
10:54 Folkol joined
11:09 yeitijem joined
11:14 m0nk3h joined
11:19 okapi joined
11:22 Folkol joined
11:51 YoY joined
11:59 sterns joined
12:03 ngmvit joined
12:23 RickDeckard joined
12:25 StephenLynx joined
12:48 michaeldgagnon joined
12:49 kexmex joined
12:51 kedare joined
13:02 ramortegui joined
13:10 okapi joined
13:19 sz0 joined
13:27 Folkol joined
13:35 tildes joined
13:36 igniting joined
13:55 gentunian joined
14:00 geoffb joined
14:12 <cornfeedhobo> does anyone know what the equivalent to 2.4's `auth=on` setting is for newer versions?
14:26 <Derick> cornfeedhobo: on the command line, it's --auth
14:26 <Derick> cornfeedhobo: in the config file: https://docs.mongodb.com/manual/administration/configuration/#security-considerations
14:27 <cornfeedhobo> Derick: thank you very much. i searched for a while :p
14:31 goldfish joined
14:32 culthero joined
14:36 culthero_ joined
14:36 blizzow joined
14:43 Folkol joined
14:47 AvianFlu joined
14:53 trevor joined
14:53 ashp joined
14:54 <ashp> Hey guys, looking for advice, a query we're running does IXSCAN instead of using the index that exists on _id: 1: https://gist.github.com/apenney/11b1620860066b136e4d480604447520 is the .explain and the evidence the index exists
14:54 <ashp> What would you guys do to fix this? :/
14:55 <Derick> IXSCAN is an index'ed lookup
14:55 <ashp> oh, hmm, one of these queries took 2700 seconds to reply
14:56 <ashp> so I assumed we weren't touching an index (cpu was 100%)
14:56 <Derick> and that explain shows that the index is used
14:56 <ashp> https://gist.github.com/apenney/29a4589c0a850ece7bdd5f8683115c96 is the actual log entry
14:56 <ashp> huh, I wonder why it hit the cluster so hard then :/
14:57 <Derick> ntoskip:4912000
14:57 <Derick> that's not skipping just 1000 as in your explain paste
14:57 <Derick> and it was 3700 seconds :-)
14:58 <Derick> more than an hour!
14:58 <ashp> ah they were iterating in 1000 chunks
14:58 <ashp> doing .skip(1000), .skip(2000), etc
14:58 <Derick> I think you shouldn't use skip here
14:58 <Derick> as a skip of 4.9 million means reading all 4.9 million documents
14:58 <ashp> oh!
14:58 <ashp> i assumed skip.. you know, skipped ;)
14:59 <Derick> nscanned:4912500 nscannedObjects:4912500
14:59 <ashp> guess we should read the docs
14:59 <Derick> tells you how many documents where read
15:00 <Derick> ashp: see: http://stackoverflow.com/questions/7228169/slow-pagination-over-tons-of-records-in-mongo
15:00 goldfish joined
15:00 <Derick> ashp: and https://sammaye.wordpress.com/2012/05/25/mongodb-paging-using-ranged-queries-avoiding-skip/ might have a solution
15:01 <ashp> awesome, appreciate it!
15:01 <ashp> we'll go read those, fix the code, and do it again
15:01 <Derick> no prob
15:01 <Derick> explain btw, can also show how long things take
15:02 <Derick> by using "executionStats" as argument as is described at https://docs.mongodb.com/manual/reference/method/cursor.explain/#cursor.explain
15:03 <ashp> oh, nice, thanks! at least this is an easy fix for us
15:09 igniting joined
15:21 orbyt_ joined
15:32 compeman joined
15:38 rook_flood joined
15:40 <rook_flood> hi folks – can a really slow query (i.e. tens of seconds) slow down other queries being made for data in the same collection? if so, is there a term for that concept?
15:44 <joshua> rook_flood: I think it depends on the storage engine https://docs.mongodb.com/manual/faq/concurrency/
15:45 <rook_flood> thanks joshua, I'll check that out
15:45 <joshua> also you can run db.currentOp() while it is running and get some info there.
15:45 <joshua> https://docs.mongodb.com/manual/reference/method/db.currentOp/
15:54 edrocks joined
15:57 jri_ joined
15:58 SkyRocknRoll joined
16:04 calum_ joined
16:05 culthero joined
16:09 brk_ joined
16:12 svm_invictvs joined
16:12 cal-tec joined
16:13 <cal-tec> hi
16:14 <cal-tec> I have an array of sub documents and I want to know the correct way to query mongo to only return the main document when all the subdocuments match a criteria. I have been trying for hours
16:16 <cal-tec> eg. {SubDocuments:[{a:true, b:xyz},{a:true, b:jfh}{a:false, b:ytu}} should not match when I want to query for a=false or a=true as the subdocuments contain both true and false
16:18 ssarah joined
16:25 raspado joined
16:26 edrocks joined
16:30 okapi joined
16:32 orbyt_ joined
16:39 rendar joined
16:39 rendar joined
16:42 clouder|grr joined
16:51 edrocks joined
16:51 edrocks joined
17:09 silenced joined
17:28 culthero joined
17:37 Mantis_ joined
17:38 Liara- joined
17:44 kexmex joined
17:46 culthero joined
17:47 artok joined
17:48 sandstrom joined
17:56 orbyt_ joined
17:56 jri joined
17:56 jri_ joined
17:58 compeman joined
18:02 Sasazuka joined
18:14 alexi5 joined
18:14 threee joined
18:21 sandstrom joined
18:27 Frostman joined
19:00 edrocks joined
19:04 dddh joined
19:05 Liara- joined
19:11 orbyt_ joined
19:20 cal-tec joined
19:29 ruairi joined
19:29 joshonth_ joined
19:29 artok joined
19:36 compeman joined
19:40 jri joined
19:49 jri_ joined
19:57 nalum joined
19:59 <nalum> hello all, is anyone using mongodb in a kubernetes cluster? I'm seeing a restart of each mongodb instance in my replicaset about once a day, where the instance receives a signal 15 and then shortly after receives a signal 6
20:03 threee joined
20:09 veebers joined
20:10 trevor_ joined
20:12 nalum joined
20:19 culthero joined
20:22 cal-tec joined
20:41 silenced joined
20:42 armyriad joined
20:56 Necromantic joined
21:02 orbyt_ joined
21:23 culthero joined
21:26 orbyt_ joined
21:28 threee joined
21:31 StephenLynx joined
21:34 Liara- joined
21:41 raspado joined
21:44 culthero joined
21:47 culthero joined
21:50 Liara- joined
22:00 Liara- joined
22:05 Liara- joined
22:23 veebers joined
22:25 threee joined
22:26 threee joined
22:26 TheFuzzball joined
22:32 orbyt_ joined
22:32 threee joined
22:36 Liara- joined
22:41 preludedrew joined
22:43 Liara- joined
22:53 TheFuzzball joined
22:54 beauvolio joined
23:08 orbyt_ joined
23:18 TheFuzzball joined
23:45 FrozenSolid joined