Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
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
- relates to
-
MB-43405 Add new query settings in Cheshire Cat to UI
- Closed