[SERVER-2726] mongostat doesn't report not indexed queries for array fields Created: 10/Mar/11 Updated: 19/Apr/12 Resolved: 10/Mar/11 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Performance, Querying, Tools, Usability |
| Affects Version/s: | 1.7.6 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Valery Khamenya | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Ubuntu 10.10 (64bit) |
||
| Backwards Compatibility: | Fully Compatible |
| Operating System: | ALL |
| Participants: |
| Description |
|
"idx miss %" field was a steady zero, whereas updates of a 1-2 rows in a 1 million collection were totally slow. the update's specification was something like {my_array_field : an_element_that_should_be_present_in_the_array}after an index was added for the array field, the process finished blazingly fast. |
| Comments |
| Comment by Eliot Horowitz (Inactive) [ 10/Mar/11 ] |
|
idx miss % is how many btree nodes have to be paged in, not whether a query uses them or not. there could be another field like "# of documents examined" but that's different |