Log file Viewer

[01:00:58] <chovy> how can i speed up this query. i have 100k docs and it times out after 3 minutes

[01:01:01] <chovy> http://sprunge.us/Y0Ng5G

[01:01:21] <chovy> think i need an index on the $match but not sure how

[01:04:14] <chovy> cryptos is an array of objects [{ symbol: 'BTC', ...}]

[01:04:15] <chovy> etc

[01:04:24] <chovy> not sure how to index that properly

[01:07:56] <d4rkp1r4t3> db.col.createIndex({ 'cryptos.symbol': 1, 'root.createdAt': -1 })

[01:08:39] <d4rkp1r4t3> Kelsar: you will have to do incremental upgrades. 3.6 -> 4.0 -> 4.2 -> 4.4

[01:09:39] <chovy> d4rkp1r4t3: i'm a little confused on this `root` thing. what is that?

[01:09:57] <d4rkp1r4t3> VectorX: check out $facet. should be able to get them all in 1 query that way

[01:10:46] <VectorX> ok

[01:11:08] <d4rkp1r4t3> chovy: its just a reference to the current document, same as $$CURRENT. https://docs.mongodb.com/manual/reference/aggregation-variables/#variable.ROOT

[01:12:00] <chovy> ok

[01:13:13] <chovy> also it seems when i add an index that effects all docs, it takes around 24 hours to take effect, even though the index is created after an hour or so

[03:48:41] <ACfromTX> Can anyone point me to documentation of how MongoDB behaves when the file system the data is stored on goes read-only, and when it fills up? (Thanks in advance for any direction or guidance you may provide.)

[06:46:40] <VectorX> i have a string time field like "00:01:18" how can i compare second from this, ie { $gte : [$field : 30] } etc to see if it is more than 30 seconds?

[09:33:12] <ACfromTX> Sorry for asking again, but can anyone point me to documentation of how MongoDB behaves when the file system the data is stored on goes read-only, and when it fills up? (Thanks in advance for any direction or guidance you may provide.)

[17:38:48] <ACfromTX> Are there other places to ask a question like mine that might be more active?

[22:41:00] <d4rkp1r4t3> ACfromTX: looks like it will just shutdown. could also result in corruption. https://jira.mongodb.org/browse/SERVER-41420

[23:23:07] <ACfromTX> d4rkp1r4t3, I think I read that JIRA ticket, but wanted to confirm that was the behavior. Does it do so in the case of a filesystem going read-only as well?