<     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 26 27  
28 29 30 31
00:13 Necro|senseless joined
00:50 synapse joined
00:51 <synapse> hello
00:57 GonzaloGM_ joined
00:58 TheFuzzball joined
01:07 irisl joined
01:10 <joannac> hi synapse
01:27 GonzaloGM__ joined
01:28 DrYucatan joined
01:30 Gwayne joined
01:30 Gwayne joined
01:35 TheFuzzball joined
01:43 michaeldgagnon joined
01:49 Necromantic joined
01:57 GonzaloGM_ joined
01:58 schmity joined
02:27 GonzaloGM__ joined
02:33 fels joined
02:42 mdorenka joined
02:48 janat08 joined
02:48 <janat08> im trying to aggregate flat schema from document subfield fields
02:49 <janat08> $group: { _id: {$skills.<fields>}?
02:57 GonzaloGM_ joined
03:28 GonzaloGM joined
03:29 <synapse> how are you joannac ?
03:41 dcrouch joined
03:58 GonzaloGM_ joined
04:14 svm_invictvs joined
04:28 GonzaloGM joined
04:30 LippyLee joined
04:33 <janat08> how do i reffer to embeded document fields as a wholte list
04:34 <janat08> so that I could group by fields containing source _ids
04:35 fels joined
04:59 GonzaloGM_ joined
05:03 armyriad joined
05:13 DrYucatan joined
05:42 YoY joined
05:48 lpin joined
05:58 armyriad joined
06:13 Mia joined
06:33 fels joined
07:00 stalled joined
07:09 fels joined
07:21 stalled joined
07:30 rendar joined
07:34 preludedrew joined
07:54 fels joined
08:14 gfidente joined
08:25 chat___ joined
08:43 klics joined
08:54 castlelore joined
09:00 evil_gordita joined
09:14 timg__ joined
09:17 kedare joined
09:24 TheFuzzball joined
09:47 okapi joined
09:57 harry1 joined
09:59 <mylord> how can i patch only some fields and also keep history of those patches.. i’ve seen plugins for either operation, but not both
10:01 <mylord> so for instagram example, say i don’t want to alter the iamge, but just the text, and keep a history of those text changes
10:11 <mylord> oh, i guess this does it https://www.npmjs.com/package/mongoose-patch-history
10:16 Aquazi joined
10:19 okapi joined
10:42 megamaced joined
11:10 undertuga joined
11:11 chat_ joined
11:11 chat_ left
11:16 DrYucatan joined
11:19 michaeldgagnon joined
11:56 yeitijem joined
11:59 StephenLynx joined
12:06 RickDeckard joined
12:19 kexmex joined
12:39 JonathanMcClare joined
12:50 harry1 joined
12:56 re1 joined
13:02 ramortegui joined
13:13 edrocks joined
13:17 DrYucatan joined
13:22 threee joined
13:28 griffindy joined
13:35 kexmex joined
13:36 cev joined
13:50 synthmeat joined
14:00 geoffb joined
14:08 dcrouch joined
14:11 klics joined
14:13 TheFuzzball joined
14:14 fels joined
14:18 strugee joined
14:37 d10n-work joined
15:03 okapi joined
15:49 jaitaiwan joined
15:49 AlgorithmWizard joined
15:52 ishanjain28 joined
15:52 <ishanjain28> Hey!
15:52 <ishanjain28> I had a question related to large scale database backups...
15:53 <ishanjain28> I am working on a system that handle 5000 requests every second. The database is around 23 GB. It takes sometime to create a backup using mongodump.
15:53 <ishanjain28> The server is written in go.
15:58 raspado joined
16:01 raspado_ joined
16:09 gentunian joined
16:09 orbyt_ joined
16:12 ishanjain28 joined
16:41 <MacWinner> i'm trying to reproduce the most basic case of Socket timeout error on a connection using mongodb + nodejs (so that I can fiddle with the socket timeout settings to see how it actually works). We are seeing some socket timeout errors in the logs in production, but I can't reproduce them easily
16:42 <MacWinner> any tips or pointers appreciated
16:43 ishanain28 joined
16:45 artok joined
16:46 svm_invictvs joined
16:46 ishanain28 joined
16:47 kexmex joined
16:48 edrocks joined
16:53 armyriad joined
17:00 edrocks joined
17:02 raspado joined
17:08 dcrouch joined
17:52 strugee joined
18:00 orbyt_ joined
18:06 Sasazuka joined
18:10 orbyt_ joined
18:19 orbyt_ joined
18:22 orbyt_ joined
18:27 AvianFlu joined
18:31 orbyt_ joined
18:50 timg__ joined
18:56 Mia joined
19:00 morrowyn joined
19:01 ishanain28 joined
19:03 ishanjain28 joined
19:05 ishanjain28 joined
19:06 ishanjain28 joined
19:06 gnarf joined
19:07 michaeldgagnon joined
19:07 ishanjain28 joined
19:20 okapi joined
19:22 strugee joined
19:25 fakingfantastic joined
19:26 <fakingfantastic> I’m new to mongo, can someone explain to me when when I do {$text: {$search: “AR-1300”}}, I get results that don’t include that exact string in my indexed data?
19:26 <fakingfantastic> But things that also in include “AR”, and “1300”, and “Axxxxx Rxxxxx"
19:27 <fakingfantastic> I also get nothing under queryPlanner.terms when I use explain(true)
19:28 <kexmex> try \- ?
19:28 <kexmex> what are you trying to do btw, trying to use regexp?
19:36 <fakingfantastic> kexmex: yeah, I tried escaping it - no difference. Im searching users: I made an index of each user’s full name and a unique ID. Just trying to search the user by that ID
19:36 <kexmex> ok so you need an exact patch right
19:36 <kexmex> match*
19:36 <fakingfantastic> db.users.find({$text: {$search: "AR\-1300"}}, {score: {$meta: "textScore"}}).sort({score:{$meta:"textScore"}})
19:36 <kexmex> what's the field name?
19:37 <fakingfantastic> Core.Full Name
19:37 <kexmex> umm
19:37 <kexmex> AR-1300 is full name?
19:37 <kexmex> or ID
19:37 <fakingfantastic> ID
19:37 <kexmex> oh, that's some full text index?
19:37 <fakingfantastic> that field is, User_ID
19:37 <kexmex> so why not do something like { user_id : "AR-1300" }
19:38 <fakingfantastic> yeah, exactly I did… db.users.createIndex({‘Core.Full Name’: ‘text’}, {‘User_ID’: ‘text’}})
19:38 uehtesham90__ joined
19:38 <kexmex> that's index to speed it up
19:38 <kexmex> if you are searching by User_ID, then you should have it first the index
19:38 <fakingfantastic> I read you need to index to do full text search: https://code.tutsplus.com/tutorials/full-text-search-in-mongodb--cms-24835
19:38 <kexmex> otherwise you'll always need a full name
19:38 <kexmex> are you doing a full text search?
19:39 <kexmex> what are you trying to do ? :)
19:39 fels joined
19:39 <kexmex> end result
19:39 <fakingfantastic> The reason is, I’m making a search API endpoint, and I just want the user to be able to do /users/search?q=Some Name, or /users/search?q=AR-1300
19:39 <kexmex> i don't think you need full text search here
19:40 <kexmex> you are just trying to lookup a user by either name or id
19:40 <kexmex> right
19:40 <fakingfantastic> indeed
19:40 <kexmex> ok so you need two indexes
19:40 <kexmex> and you need to use $or
19:40 <kexmex> this has nothing to do with full-text search
19:40 <fakingfantastic> kinda felt like fts to me, but like I said.. im new :)
19:41 <kexmex> fts is like when you wanna search for strings wtihin big blobs of text and shit
19:41 <fakingfantastic> i feel you
19:41 <kexmex> you wanna do something like
19:41 <kexmex> where userId = <id> or name = <name>
19:41 <kexmex> right
19:41 <kexmex> so you want two indexes, one for userId and one for Name i think
19:41 <kexmex> and then you wanna run an $or query
19:41 <fakingfantastic> yeah, and each one of those can be subsets of the hit too
19:42 <kexmex> subsets like partial patches?
19:42 <kexmex> matches*
19:42 <fakingfantastic> so like name = “Cha” … get’s me Charles, or Chaplin, or Chance
19:42 <kexmex> what about
19:42 <kexmex> in the middle of the string
19:42 <fakingfantastic> sure
19:42 <kexmex> well
19:42 <kexmex> you can do something like { name : /arles/ }
19:43 <kexmex> that's regexp
19:43 <fakingfantastic> ahh… mongo and regex
19:43 <kexmex> not sure what kinda index you need fro that though
19:43 <fakingfantastic> I swear, I’m so used to MySQL that it’s actually limiting me from thinking NoSQL
19:43 <kexmex> regular index would work for like
19:43 <kexmex> name like 'Cha%'
19:43 <kexmex> but prolly is no good for name like '%Cha%'
19:44 <kexmex> so maybe you need $text :)
19:45 <fakingfantastic> all good, i can start from here
19:45 <fakingfantastic> when you said, “not sure what kinda index you need for that”… did you mean “regex?"
19:45 <fakingfantastic> Or do I actually need an index if I’m using $or… cause it seems to be working fine
19:46 <kexmex> well i thought you need exact match
19:47 <fakingfantastic> db.users.find({$or: [{'Core.Full Name': /AR-130/}, {‘User_ID': /AR-130/}]})
19:47 <fakingfantastic> That’s working spot on
19:47 <kexmex> yea but as your DB grows i am not sure
19:47 <kexmex> if it will perform :)
19:48 <kexmex> u might wanna esape - is it part of regex?
19:55 <fakingfantastic> - is a range operator, but I believe it need to be in square brackets
19:55 <fakingfantastic> so like /Plan\s[A-Z]/
20:01 orbyt_ joined
20:02 rendar joined
20:02 rendar joined
20:05 StephenLynx joined
20:07 timg__ joined
20:24 okapi joined
20:29 okapi joined
20:30 edrocks joined
20:33 buttmancer joined
20:50 itaipu joined
21:01 okapi joined
21:32 strugee joined
21:42 StephenLynx joined
21:50 strugee joined
21:56 michaeldgagnon joined
21:59 Blackbeard joined
22:04 edrocks joined
22:04 okapi joined
22:05 joshontheweb joined
22:09 orbyt_ joined
22:10 kexmex joined
22:19 timg__ joined
22:47 strugee joined
22:59 kexmex joined
23:13 MacWinner joined
23:20 sterns joined
23:20 timg__ joined
23:34 strugee joined
23:41 <MacWinner> if my mongodb query .explain() results says "FETCH" in the winning plan, does that mean the query is not using indexes?
23:48 jeffreylevesque joined
23:48 <jeffreylevesque> what is the local database?
23:50 <jeffreylevesque> ah nvm
23:51 <jeffreylevesque> was just reading https://docs.mongodb.com/manual/reference/built-in-roles/#readWriteAnyDatabase
23:51 <jeffreylevesque> so basically, if i creaate another database this would grant access to it
23:51 <jeffreylevesque> but, local comes with base install
23:51 <jeffreylevesque> and this role doesn't give permission to local
23:53 YoY joined
23:58 <MacWinner> seems like the ordering in which i put query fields in my query object affects the mongodb winningPlan selection for query
23:58 <MacWinner> is this expected?
23:59 Lujeni joined