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

Add new query settings in Cheshire Cat to UI

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • Cheshire-Cat
    • 7.0.0
    • UI
    • 1

    Description

      The following query setting should be added to the UI:

      Name: "Transaction Timeout"
      Query parameter name: txtimeout
      Default values : "0ms"

      Name: "Memory Quota"
      parameter name : memory-quota
      Default values : 0
      Quantity : MB

      Name: "Use Cost-Based Optimizer"
      parameter name : use-cbo
      Default value : true

      Ideally these settings should only show when the cluster compat mode is at level 7.0.

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-43405
          # Subject Branch Project Status CR V

          Activity

            Build couchbase-server-7.0.0-4244 contains ns_server commit 894e5cf with commit message:
            MB-43405: add new query settings to UI

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-4244 contains ns_server commit 894e5cf with commit message: MB-43405 : add new query settings to UI

            Dave Finlay Transaction timeout default value observed on UI as 120 so should it be 0 or 120.

            And I didnt observe Memory Quota on UI. Could you please confirm.

            deepika.verma Deepika Verma (Inactive) added a comment - Dave Finlay  Transaction timeout default value observed on UI as 120 so should it be 0 or 120. And I didnt observe Memory Quota on UI. Could you please confirm.
            dfinlay Dave Finlay added a comment -

            Deepika - the settings that this ticket asked for are on the Settings page under "Advanced Query Settings" and apply to all queries. I think this "Runtime Preferences" panel is associated with the Query Workbench and only apply to queries run through it. (Eben Haber: can you confirm or correct my statement on this?)

            dfinlay Dave Finlay added a comment - Deepika - the settings that this ticket asked for are on the Settings page under "Advanced Query Settings" and apply to all queries. I think this "Runtime Preferences" panel is associated with the Query Workbench and only apply to queries run through it. ( Eben Haber : can you confirm or correct my statement on this?)
            eben Eben Haber added a comment -

            Dave Finlay - you are correct, all of those settings belong on the "Settings" under "Advanced Query Settings":

             

            eben Eben Haber added a comment - Dave Finlay  - you are correct, all of those settings belong on the "Settings" under "Advanced Query Settings":  
            deepika.verma Deepika Verma (Inactive) added a comment - Thanks Eben Haber  and Dave Finlay

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              dfinlay Dave Finlay
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty