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

Per index access stats

          Details

          • Epic Name:
            Index Stats
          • Backwards Compatibility:
            Major Change
          • Sprint:
            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

                Sub-task - The sub-task of the issue 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.
                • Open

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

                • 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:
                      73 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: