Manage query engine settings
_couchbase-cli setting-query [--cluster <url>] [--username <user>]
[--password <password>] [--get] [--set] [--pipeline-batch <num>]
[--pipeline-cap <num>] [--scan-cap <size>] [--timeout <ms>]
[--prepared-limit <max>] [--completed-limit <max>]
[--log-level <trace|debug|info|warn|error|server|none>]
[--max-parallelism <max>] [--n1ql-feature-control <num>]
- --get
-
Retrieve current query service settings.
- --set
-
Set query engine settings.
- --pipeline-batch <num>
-
Number of items execution operators can batch, the default is 16.
- --pipeline-cap <num>
-
Maximum number of items each execution operator can buffer, the default 512.
- --scan-cap <size>
-
Maximum buffer size for index scans; use zero or negative value to disable. The default 512.
- --timeout <ms>
-
Server execution timeout; use zero or negative value to disable. By default is unlimited.
- --prepared-limit <max>
-
Maximum number of prepared statements, the default is 16384.
- --completed-limit <max>
-
Maximum number of completed requests, the default is 4000.
- --log-level <trace|debug|info|warn|error|server|none>
-
Query engine log level, the default level is info.
- --max-parallelism <max>
-
Maximum parallelism per query; use zero or negative value to disable. The default is 1.
- --n1ql-feature-control <num>
-
N1QL Feature Controls. 0x0001 (1) Disable Index Aggregation
To retrieve the query settings:
$ couchbase-cli setting-query -c 127.0.01:8091 -u Administrator \ -p password --get
To set any of the query settings for example maximum parallelism and log level:
$ couchbase-cli setting-query -c 127.0.01:8091 -u Administrator \ -p password --set --log-level debug --max-parallelism 4
man:couchbase-cli[1]