Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-44432

Per index access stats

    XMLWordPrintableJSON

Details

    • Major Change
    • Query 2.7.8, Quint Iteration 7, QuInt 8 08/28/15, Quint 9 09/18/15

    Description

      It would be useful to be able to get stats from individual indexes about how often they are used. You can see whether a specific query uses certain indexes using explain() but this would allow you to easily see if the index is being used at all. It could just be a simple incrementing counter every time the index gets used.

      Attachments

        Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-19504 Remove indexStats command artifacts

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-2006 Flag unused indexes on the database server

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-15224 Basic index stats

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-18245 Tracking of indexes being used

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-20735 Store date of last use for each index

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-4202 Add a way to get stats on number of queries that hit an index, per collection

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-7318 Implement index lastUsed timestamp

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Task - A task that needs to be done. SERVER-23655 CollectionInfoCache is not invalidated when starting an index build

          • Critical - P2 - Crashes, loss of data, severe memory leak.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-5828 Metric/Stats Tracking

          • Major - P3 - Major loss of function.
          • Closed
          related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-9306 Ability to temporarily forbid query optimizer from using index ("invisible index")

          • Major - P3 - Major loss of function.
          • Closed

          Task - A task that needs to be done. DOCS-6147 Create documentation $indexStats aggregation source

          • Major - P3 - Major loss of function.
          • Closed

          Task - A task that needs to be done. SERVER-20509 Create shell helper for cluster index stats analysis

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-2178 Track stats per db/collection

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-16245 Expose index statistics for WiredTiger

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              Votes:
              90 Vote for this issue
              Watchers:
              71 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: