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

UI Support for Index Advisor

    XMLWordPrintable

Details

    • 1

    Description

      Currently, we support "Advise" in UI.

      We also need better support for Advisor.

      We can use:

      SELECT ADVISOR({"action": "start", "response": "0s", "duration": "1h"}) AS Collect;

      that  returns a sessionid:

      "session": "4b5edc0e-c288-4754-9ac9-1f666b9d31cc"

      and starts recoding all the statements until 

      SELECT ADVISOR({"action": "stop", "session": "4b5edc0e-c288-4754-9ac9-1f666b9d31cc"}) AS Stop;

      is issued 

      or a certain time limit is set.

      We then get recommendations by 

      SELECT ADVISOR({"action": "get", "session": "4b5edc0e-c288-4754-9ac9-1f666b9d31cc"}) AS Get;

       

      Instead of giving all these textually, can we get a nice UI with "Start Advisor", "Stop Advisor","List Recommendations" or a separate tab altogether?

       

      Discussed in meeting with Eben and Rob on Oct 13 2020

       

       

       

      Attachments

        Issue Links

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

          Activity

            People

              eben Eben Haber
              kamini.jagtiani Kamini Jagtiani
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty