Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-29735

Option to find out un-used indexes

    XMLWordPrintable

Details

    Description

      Raising this to track CBSE-5276

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DOC-5671 [GSI] Document a new stat available for knowing last scan time of an index

          • Major - Major loss of function.
          • Resolved
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            Ascending order - Click to sort in descending order
            eben Eben Haber added a comment -

            This is a really interesting idea. It might be very helpful to the users to be able to see which of their indexes are used a lot, and which aren't used at all.

            eben Eben Haber added a comment - This is a really interesting idea. It might be very helpful to the users to be able to see which of their indexes are used a lot, and which aren't used at all.
            prathibha Prathibha Bisarahalli (Inactive) added a comment -

            This will be part of Index Advisor feature for Mad-Hatter

            prathibha Prathibha Bisarahalli (Inactive) added a comment - This will be part of Index Advisor feature for Mad-Hatter
            jeelan.poola Jeelan Poola added a comment -

            We will need below stats to begin with
            1. avg queries per second per index in the last 'N' mins/secs
            2. last queried timestamp per index

            In addition, it will be useful to persist some of these stats.

            jeelan.poola Jeelan Poola added a comment - We will need below stats to begin with 1. avg queries per second per index in the last 'N' mins/secs 2. last queried timestamp per index In addition, it will be useful to persist some of these stats.
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.5.0-2184 contains indexing commit dff08c1 with commit message:
            MB-29735: Introduce stats persistence and add stat for last query timestamp

            build-team Couchbase Build Team added a comment - Build couchbase-server-6.5.0-2184 contains indexing commit dff08c1 with commit message: MB-29735 : Introduce stats persistence and add stat for last query timestamp
            mihir.kamdar Mihir Kamdar (Inactive) added a comment -

            Closing this as this is already tested in Mad-hatter and tests are automated as well.

            mihir.kamdar Mihir Kamdar (Inactive) added a comment - Closing this as this is already tested in Mad-hatter and tests are automated as well.

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              jeelan.poola Jeelan Poola
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty