Timeline for optimized query mongo find
Current License: CC BY-SA 4.0
25 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 27 at 12:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 23 at 2:46 | comment | added | prasad_ |
Unless you use _id field in the query predicate, the default index on the _id will not be used. For any index to be used, it needs to be in the query filter fields (in case of compound index all the fields of the index or the index-prefix fields need to be used). You can always verify any index usage by generating a query plan using the explain. This will show a COLLSCAN or IXSCAN (along with the index used) as appropriate.
|
|
| May 22 at 17:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 22 at 22:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 22, 2023 at 15:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 21, 2023 at 11:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 16, 2023 at 20:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 17, 2022 at 22:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 5, 2022 at 8:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 1, 2022 at 15:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 31, 2021 at 3:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 2, 2021 at 19:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 27, 2020 at 15:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 24, 2020 at 8:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 24, 2020 at 21:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 21, 2019 at 11:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 7, 2019 at 9:46 | history | edited | Slim | CC BY-SA 4.0 |
added 322 characters in body
|
| May 7, 2019 at 5:43 | comment | added | Stennie |
Note: if you upgrade to MongoDB 4.0.9+ (or the upcoming 3.6.13 release when available), improved detection of available RAM within containers should no longer require manual adjustment of the cacheSizeGB setting.
|
|
| May 7, 2019 at 5:39 | comment | added | Stennie |
Can you elaborate on your "crashes the mongo container" comment and the specific version of MongoDB? I suspect your issue is related to detecting available RAM in your Docker deployment. As per the MongoDB Production Notes: If you run mongod in a container (e.g. lxc, cgroups, Docker, etc.) that does not have access to all of the RAM available in a system, you must set storage.wiredTiger.engineConfig.cacheSizeGB to a value less than the amount of RAM available in the container. The default is 50% of (available RAM -1 GB).
|
|
| May 6, 2019 at 8:54 | history | edited | Slim | CC BY-SA 4.0 |
added 200 characters in body
|
| May 6, 2019 at 8:02 | history | edited | Slim | CC BY-SA 4.0 |
added 66 characters in body
|
| May 6, 2019 at 7:56 | history | edited | Slim | CC BY-SA 4.0 |
added 97 characters in body
|
| May 5, 2019 at 14:05 | answer | added | Md Haidar Ali Khan | timeline score: 0 | |
| May 5, 2019 at 10:47 | comment | added | Md Haidar Ali Khan | What is the MongoDB version(x,y,z)? | |
| May 5, 2019 at 7:54 | history | asked | Slim | CC BY-SA 4.0 |