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

[FTS] Drop in throughput for N1fty QF2 and QF3 queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.1.0
    • 7.1.0
    • fts
    • 7.1.0-1038
    • Untriaged
    • 1
    • Yes

    Description

      Test run : Avg. Query Throughput (queries/sec), QF2, Range Scan, FTS, not_bounded
      Measurements:

      Combined html reports : http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=iris_710-1027_access_e237&snapshot=iris_710-1038_access_9c2c
      In this graph ; builds we are seeing an issue with are in orange and maroon (dark red).
      We are seeing no data points for graphs titled query_requests and query_selects  for builds 7.1.0-1031 (dark red / maroon) and 7.1.0-1038 (orange)

      Sample of the Query Run : SELECT * FROM `bucket-1` AS t1 WHERE SEARCH(t1, {"explain": false, "query":

      {"field": "email", "match": "abs@sdfewra"}

      , "score":"none"}, {"index":"perf_fts_index"})

      The match string changes ; based on the values generated for the test.

      From the above numbers ; this is seen for the first time in build : 7.0.0-1031 ; where there is a n1fty change and a cbgt change .

      Change log table for build 7.1.0-1031: 

      Component Commit id Commit message
      cbgt 39683a718120202967809e093810d7e95411bcc5 MB-39263: Move iterateChildren /RunObserveChildren to v2 api metakv
       
      As part of a multi-stage process to move both of these api's to the V2
      version, we are first changing all of these api's to the v2 version,
      at which point we will duplicate it, without the v2 label, and then
      eventually drop the v2 label in all services and finally remove the
      duplicate in metakv.
      n1fty d667bbe4ceda3ff62f4636721f9b00eec2163b35 MB-46978: Switch verification to use sear index
      + Previously used in-memory upsidedown/moss
      + Will need to be merged with:
      http://review.couchbase.org/c/query/+/154385

      Changelog link : here

      Attachments

        Issue Links

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

          Activity

            People

              jyotsna.nayak Jyotsna Nayak
              jyotsna.nayak Jyotsna Nayak
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty