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

sequential scan should be disabled in Capella provisioned profile

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 7.6.0
    • 7.6.0
    • ns_server
    • Untriaged
    • 0
    • Unknown

    Description

      On upgrade to 7.6 or when we have new provisioned cluster, sequential scan should be disabled in Capella provisioned profile. They can be disabled in the query settings n1ql feature control setting.

      From Kamini Jagtiani
      We can turn sequential scans off by ”OR”ing the current n1ql_feat_ctrl with 0x0000004000 (Decimal: 16,384).I believe the current value for n1ql_feat_ctrl is 4c(Decimal:76).
      So the new value should be 0x404c(Decimal: 16460) to turn it off.
      It can be done via UI(N1QL Feature Controller under advanced query settings) or curl

      curl -s -u Administrator:password http://localhost:8091/settings/querySettings -d 'queryN1QLFeatCtrl=16460'
      

      This will disable sequential scan at the cluster level for all nodes.

      Attachments

        Issue Links

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

          Activity

            People

              aman.srivastava Aman Srivastava
              Abhijeeth.Nuthan Abhijeeth Nuthan
              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