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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            jeelan.poola Jeelan Poola created issue -
            jeelan.poola Jeelan Poola made changes -
            Field Original Value New Value
            Link This issue relates to CBSE-5276 [ CBSE-5276 ]
            jeelan.poola Jeelan Poola made changes -
            Fix Version/s Mad-Hatter [ 15037 ]
            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.
            matt.carabine Matt Carabine (Inactive) made changes -
            Link This issue blocks CBSE-5361 [ CBSE-5361 ]
            jeelan.poola Jeelan Poola made changes -
            Assignee Jeelan Poola [ jeelan.poola ] Amit Kulkarni [ amit.kulkarni ]

            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
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Assignee Amit Kulkarni [ amit.kulkarni ] Prathibha Bisarahalli [ prathibha ]
            jliang John Liang made changes -
            Labels RMS
            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.
            jeelan.poola Jeelan Poola made changes -
            Priority Minor [ 4 ] Critical [ 2 ]
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Comment [ Filed MB-32200 for tracking new stats needed. Keeping this ticket specifically for providing option for unused indexes. ]
            jeelan.poola Jeelan Poola made changes -
            Labels RMS RMS mad-hatter-committed
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Labels RMS mad-hatter-committed RMS mad-hatter-committed needs-qe

            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
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Actual End 2019-01-31 12:08 (issue has been resolved)
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Link This issue relates to DOC-5671 [ DOC-5671 ]
            jose.molina Jose Molina made changes -
            Link This issue relates to CBSE-7339 [ CBSE-7339 ]
            jose.molina Jose Molina made changes -
            Link This issue relates to CBSE-7339 [ CBSE-7339 ]
            ritam.sharma Ritam Sharma made changes -
            Assignee Prathibha Bisarahalli [ prathibha ] Mihir Kamdar [ mihir.kamdar ]

            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.
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]

            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