[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

Generated at Thu Feb 08 03:01:01 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.