-
Type: New Feature
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Indexes
-
Labels:None
-
3
Compass version: 1.18
Issue description
This was brought up in a support case (linked) with a customer that when connected to a cluster through the mongos saw that index utilisation was displayed as 0.
Due to this they decided to delete the index causing issues in their production environment as, in fact, the application was using the index.
The misleading values are due to an expected behaviour on the server described in HELP-7444 that is also aggravated in Compass as the source for the displayed value is not being expose.
Quick fix
Add an additional column to the Index summary table stating from what process the result came from. When running through the shell when connected to a mongos I get:
mongos> db.bar.aggregate([{ $indexStats: { } } ] ).pretty() { "name" : "a_1", "key" : { "a" : 1 }, "host" : "enriquemac:27021", "accesses" : { "ops" : NumberLong(1), "since" : ISODate("2019-06-14T11:05:34.637Z") } } { "name" : "_id_", "key" : { "_id" : 1 }, "host" : "enriquemac:27021", "accesses" : { "ops" : NumberLong(0), "since" : ISODate("2019-06-14T11:00:41.252Z") } }
Definite fix
Leverage the functionality of SERVER-20509 when implemented.