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

Add new query settings to CLI

    XMLWordPrintable

Details

    • Untriaged
    • Windows 64-bit
    • 1
    • Unknown

    Description

      On UI, we have option to enable "Use Cost-Based Optimizer" as well as set the "Memory quota" and "Transaction timeout":

      Where from CLI no option found in below link to set CBO.

      https://docs.couchbase.com/server/7.0/cli/cbcli/couchbase-cli-setting-query.html

      when get option is executed to get present settings for query, below is the output observed where CBO as true observed.

      couchbase-cli setting-query -c 172.23.97.87:8091 -u Administrator -p password --get {"queryTmpSpaceDir": "C:/Program Files/Couchbase/Server/var/lib/couchbase/tmp", "queryTmpSpaceSize": 5120, "queryPipelineBatch": 16, "queryPipelineCap": 512, "queryScanCap": 512, "queryTimeout": 0, "queryPreparedLimit": 16384, "queryCompletedLimit": 4000, "queryCompletedThreshold": 1000, "queryLogLevel": "info", "queryMaxParallelism": 1, "queryN1QLFeatCtrl": 76, "queryTxTimeout": "0ms", "queryMemoryQuota": 0, "queryUseCBO": true, "queryCleanupClientAttempts": true, "queryCleanupLostAttempts": true, "queryCleanupWindow": "60s", "queryNumAtrs": 1024, "queryCurlWhitelist": {"all_access": false, "allowed_urls": [], "disallowed_urls": []}}

      It should update in doc also.

       

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              deepika.verma Deepika Verma (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty