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

[Query] Need Query Server settings

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.0.0
    • Fix Version/s: Mad-Hatter
    • Component/s: ns_server, query
    • Labels:
      None

      Description

      [Query] Need Query Server settings

        Attachments

          Issue Links

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

            Activity

            Hide
            anil Anil Kumar added a comment -

            Prasad Varakur we need the details about what query server parameters are needed. can you please work with Keshav to gather that. Thanks!

            Show
            anil Anil Kumar added a comment - Prasad Varakur we need the details about what query server parameters are needed. can you please work with Keshav to gather that. Thanks!
            Hide
            keshav Keshav Murthy added a comment -

            Hi Anil Kumar

            The dynamic parameters are the REST changeable parameters.

            {"completed-limit":4000,"completed-threshold":1000,"controls":false,"cpuprofile":"","debug":false,"keep-alive-length":16384,"loglevel":"INFO","max-parallelism":1,"memprofile":"","pipeline-batch":16,"pipeline-cap":512,"pretty":true,"profile":"off","request-size-cap":67108864,"scan-cap":0,"servicers":64,"timeout":0}

            The static (startup time) parameters are below.  In addition, we'd need the ns_server to set env variables like GC (and other Golang parameters).

            root@s61211-cnt56 ~]# /opt/couchbase/bin/cbq-engine -help

            2017-01-30T04:13:59.938-08:00 [Error] GetSettingsConfig() failed: Get /_metakv/indexing/settings/config: Unable to initialize cbauth's revrpc: cbauth environment variable CBAUTH_REVRPC_URL is not set

            Usage of /opt/couchbase/bin/cbq-engine:

              -acctstore string

                Accounting store address (http://URL or stub (default "gometrics:")

              -certfile string

                HTTPS certificate file

              -completed-limit int

                maximum number of completed requests (default 4000)

              -completed-threshold int

                cache completed query lasting longer than this many milliseconds (default 1000)

              -configstore string

                Configuration store address (http://URL or stub (default "stub:")

              -controls

                Response to include controls section

              -cpuprofile string

                write cpu profile to file

              -datastore string

                Datastore address (http://URL or dir:PATH or mock

              -debug

                Debug mode

              -enterprise

                Enterprise mode (default true)

              -http string

                HTTP service address (default ":8093")

              -https string

                HTTPS service address (default ":18093")

              -keep-alive-length int

                maximum size of buffered result (default 16384)

              -keyfile string

                HTTPS private key file

              -logger string

                Logger implementation

              -loglevel string

                Log level: debug, trace, info, warn, error, severe, none (default "info")

              -max-parallelism int

                Maximum parallelism per query; use zero or negative value to disable (default 1)

              -memprofile string

                write memory profile to this file

              -metrics

                Whether to provide metrics (default true)

              -mutation-limit int

                Maximum LIMIT for data modification statements; use zero or negative value to disable

              -namespace string

                Default namespace (default "default")

              -order-limit int

                Maximum LIMIT for ORDER BY clauses; use zero or negative value to disable

              -pipeline-batch int

                Number of items execution operators can batch (default 16)

              -pipeline-cap int

                Maximum number of items each execution operator can buffer (default 512)

              -plus-servicers int

                Plus servicer count (default 256)

              -pretty

                Pretty output (default true)

              -profile string

                Profiling state: off, phases, timings (default "off")

              -readonly

                Read-only mode

              -request-cap int

                Maximum number of queued requests per logical CPU (default 1024)

              -request-size-cap int

                Maximum size of a request (default 67108864)

              -scan-cap int

                Maximum buffer size for primary index scans; use zero or negative value to disable

              -servicers int

                Servicer count (default 64)

              -signature

                Whether to provide signature (default true)

              -ssl_minimum_protocol string

                TLS minimum version ('tlsv1'/'tlsv1.1'/'tlsv1.2') (default "tlsv1")

              -static-path string

                Path to static content (default "static")

              -timeout duration

                Server execution timeout, e.g. 500ms or 2s; use zero or negative value to disable

            [root@s61211-cnt56 ~]#

            Show
            keshav Keshav Murthy added a comment - Hi Anil Kumar :  The dynamic parameters are the REST changeable parameters. {"completed-limit":4000,"completed-threshold":1000,"controls":false,"cpuprofile":"","debug":false,"keep-alive-length":16384,"loglevel":"INFO","max-parallelism":1,"memprofile":"","pipeline-batch":16,"pipeline-cap":512,"pretty":true,"profile":"off","request-size-cap":67108864,"scan-cap":0,"servicers":64,"timeout":0} The static (startup time) parameters are below.  In addition, we'd need the ns_server to set env variables like GC (and other Golang parameters). root@s61211-cnt56 ~]# /opt/couchbase/bin/cbq-engine -help 2017-01-30T04:13:59.938-08:00 [Error] GetSettingsConfig() failed: Get /_metakv/indexing/settings/config: Unable to initialize cbauth's revrpc: cbauth environment variable CBAUTH_REVRPC_URL is not set Usage of /opt/couchbase/bin/cbq-engine:   -acctstore string     Accounting store address ( http://URL or stub (default "gometrics:")   -certfile string     HTTPS certificate file   -completed-limit int     maximum number of completed requests (default 4000)   -completed-threshold int     cache completed query lasting longer than this many milliseconds (default 1000)   -configstore string     Configuration store address ( http://URL or stub (default "stub:")   -controls     Response to include controls section   -cpuprofile string     write cpu profile to file   -datastore string     Datastore address ( http://URL or dir:PATH or mock   -debug     Debug mode   -enterprise     Enterprise mode (default true)   -http string     HTTP service address (default ":8093")   -https string     HTTPS service address (default ":18093")   -keep-alive-length int     maximum size of buffered result (default 16384)   -keyfile string     HTTPS private key file   -logger string     Logger implementation   -loglevel string     Log level: debug, trace, info, warn, error, severe, none (default "info")   -max-parallelism int     Maximum parallelism per query; use zero or negative value to disable (default 1)   -memprofile string     write memory profile to this file   -metrics     Whether to provide metrics (default true)   -mutation-limit int     Maximum LIMIT for data modification statements; use zero or negative value to disable   -namespace string     Default namespace (default "default")   -order-limit int     Maximum LIMIT for ORDER BY clauses; use zero or negative value to disable   -pipeline-batch int     Number of items execution operators can batch (default 16)   -pipeline-cap int     Maximum number of items each execution operator can buffer (default 512)   -plus-servicers int     Plus servicer count (default 256)   -pretty     Pretty output (default true)   -profile string     Profiling state: off, phases, timings (default "off")   -readonly     Read-only mode   -request-cap int     Maximum number of queued requests per logical CPU (default 1024)   -request-size-cap int     Maximum size of a request (default 67108864)   -scan-cap int     Maximum buffer size for primary index scans; use zero or negative value to disable   -servicers int     Servicer count (default 64)   -signature     Whether to provide signature (default true)   -ssl_minimum_protocol string     TLS minimum version ('tlsv1'/'tlsv1.1'/'tlsv1.2') (default "tlsv1")   -static-path string     Path to static content (default "static")   -timeout duration     Server execution timeout, e.g. 500ms or 2s; use zero or negative value to disable [root@s61211-cnt56 ~] #
            Hide
            mikew Mike Wiederhold [X] (Inactive) added a comment -

            Some ns_server work is required for this that we cannot fit into the schedule for Spock.

            Show
            mikew Mike Wiederhold [X] (Inactive) added a comment - Some ns_server work is required for this that we cannot fit into the schedule for Spock.
            Hide
            keshav Keshav Murthy added a comment -

            Here are the parameters we need to set globally via ns_server in UI.

            Full document at: https://docs.google.com/document/d/1Mw_YIjNfK0QuskbQWlewvyhwKKZ-7qqrRLrbx0k0hBk/edit

            Query parameters in Couchbase Webconsole UI.

             -pipeline-batch int

               Number of items execution operators can batch (default 16)

             -pipeline-cap int

               Maximum number of items each execution operator can buffer (default 512)

             -scan-cap int

               Maximum buffer size for index scans; use zero or negative value to disable (default 512)

             -timeout duration

               Server execution timeout, e.g. 500ms or 2s; use zero or negative value to disable

             -prepared-limit int

               maximum number of prepared statements (default 16384)

             -completed-limit int

               maximum number of completed requests (default 4000)

             -completed-threshold int

               cache completed query lasting longer than this many milliseconds (default 1000)

             -loglevel string

               Log level: debug, trace, info, warn, error, severe, none (default "info")

             -max-parallelism int

               Maximum parallelism per query; use zero or negative value to disable (default 1)

             -n1ql-feat-ctrl uint

               N1QL Feature Controls

            Show
            keshav Keshav Murthy added a comment - Here are the parameters we need to set globally via ns_server in UI. Full document at: https://docs.google.com/document/d/1Mw_YIjNfK0QuskbQWlewvyhwKKZ-7qqrRLrbx0k0hBk/edit Query parameters in Couchbase Webconsole UI.  -pipeline-batch int    Number of items execution operators can batch (default 16)  -pipeline-cap int    Maximum number of items each execution operator can buffer (default 512)  -scan-cap int    Maximum buffer size for index scans; use zero or negative value to disable (default 512)  -timeout duration    Server execution timeout, e.g. 500ms or 2s; use zero or negative value to disable  -prepared-limit int    maximum number of prepared statements (default 16384)  -completed-limit int    maximum number of completed requests (default 4000)  -completed-threshold int    cache completed query lasting longer than this many milliseconds (default 1000)  -loglevel string    Log level: debug, trace, info, warn, error, severe, none (default "info")  -max-parallelism int    Maximum parallelism per query; use zero or negative value to disable (default 1)  -n1ql-feat-ctrl uint    N1QL Feature Controls
            Hide
            keshav Keshav Murthy added a comment -

            Anil Kumar, Chaitra Ramarao: Can you please talk to Dave and decide the target. 

            This is a pain customers are living with so far. 

            Show
            keshav Keshav Murthy added a comment - Anil Kumar , Chaitra Ramarao : Can you please talk to Dave and decide the target.  This is a pain customers are living with so far. 
            Hide
            chaitra.ramarao Chaitra Ramarao added a comment -

            @Keshav : I have bubbled it up to Dave and Chin to include it in Mad Hatter. Right now it is targeted for Mad Hatter. But ns_server has to confirm.

            Show
            chaitra.ramarao Chaitra Ramarao added a comment - @Keshav : I have bubbled it up to Dave and Chin to include it in Mad Hatter. Right now it is targeted for Mad Hatter. But ns_server has to confirm.
            Hide
            chaitra.ramarao Chaitra Ramarao added a comment -

            Sitaram Vemulapalli : It is with ns_Server, we will wait for Dave to confirm.

            Show
            chaitra.ramarao Chaitra Ramarao added a comment - Sitaram Vemulapalli : It is with ns_Server, we will wait for Dave to confirm.

              People

              • Assignee:
                dfinlay Dave Finlay
                Reporter:
                anil Anil Kumar
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Gerrit Reviews

                  There are no open Gerrit changes

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.