Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-3697

Index utilisation inaccuracies and untrusted values

    • Type: Icon: New Feature New Feature
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 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.

            Assignee:
            Unassigned Unassigned
            Reporter:
            enrique.garneloprediger@mongodb.com Enrique Garnelo Prediger
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated: