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.

            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

            • 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

              Issues in Epic

               
              		 SERVER-20509 Create shell helper for cluster index stats analysis Task Closed James Wahlin
              Actions

                Activity

                • Comments
                Ascending order - Click to sort in descending order
                7 older comments
                Hide
                Permalink
                tpneumat Jeremy added a comment - - edited

                We have system that automatically creates indexes when needed-- this would be especially helpful, allowing us to auto-remove them when no longer used or when underutilized.

                Show
                tpneumat Jeremy added a comment - - edited We have system that automatically creates indexes when needed-- this would be especially helpful, allowing us to auto-remove them when no longer used or when underutilized.
                Hide
                Permalink
                richard.kershaw@corethree.net Richard K. added a comment -

                One more vote for this feature - we have some huge indexes it'd be great to dispose of just as soon as we're 100% sure they're completely unused.

                Show
                richard.kershaw@corethree.net Richard K. added a comment - One more vote for this feature - we have some huge indexes it'd be great to dispose of just as soon as we're 100% sure they're completely unused.
                Hide
                Permalink
                rgpublic rgpublic added a comment -

                "One more thing" I'd like to add: A simple counter would already be a huge step forward, but the date of last access would be even better. Otherwise one would have to compare the values of individual indexes between two dates and find out whether the counter incremented or not. Certainly not that difficult, but while you are at it you might want to consider saving the last access date as well.

                Show
                rgpublic rgpublic added a comment - "One more thing" I'd like to add: A simple counter would already be a huge step forward, but the date of last access would be even better. Otherwise one would have to compare the values of individual indexes between two dates and find out whether the counter incremented or not. Certainly not that difficult, but while you are at it you might want to consider saving the last access date as well.
                Hide
                Permalink
                avivais Avi Vaisenberger added a comment -

                +1 - Should be really really helpful and replace all the hassle going through the profiler docs

                Show
                avivais Avi Vaisenberger added a comment - +1 - Should be really really helpful and replace all the hassle going through the profiler docs
                Hide
                Permalink
                xgen-internal-githook Githook User added a comment -

                Author:

                {u'name': u'James Wahlin', u'email': u'james.wahlin@10gen.com'}

                Message: SERVER-2227 Addition of index usage statistics
                Branch: master
                https://github.com/mongodb/mongo/commit/ae9df7fb11cf359686699aeb9539cb6dc35de675

                Show
                xgen-internal-githook Githook User added a comment - Author: {u'name': u'James Wahlin', u'email': u'james.wahlin@10gen.com'} Message: SERVER-2227 Addition of index usage statistics Branch: master https://github.com/mongodb/mongo/commit/ae9df7fb11cf359686699aeb9539cb6dc35de675

                  People

                  • Votes:
                    90 Vote for this issue
                    Watchers:
                    72 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                        Agile