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

[N1FTY]Increase in latency observed in QF3 Queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • 7.1.0
    • 7.1.0
    • fts
    • Untriaged
    • 1
    • Unknown

    Description

      Test run : 90th percentile query latency (ms), QF3, Range Scan, 10K queries/sec

      Type of query run: 
      SELECT name AS _name, street AS _street FROM `bucket-1` AS t1 WHERE SEARCH(t1, {"explain": false, "query":

      {"field": "capped_small", "match": "apps"}

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

      Measurements: 

      Build Latency (ms)
      7.1.0-1030 ​189
      7.1.0-1038 1864
      7.1.0-1119 607
      7.1.0-1169 1307

      link to the job that uses build: 7.1.0-1169 : http://perf.jenkins.couchbase.com/job/iris/25900/
      Logs for the job that uses build: 7.1.0-1169 :
      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-iris-25900/172.23.100.45.zip
      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-iris-25900/172.23.100.55.zip
      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-iris-25900/172.23.100.70.zip
      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-iris-25900/172.23.100.71.zip
      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-iris-25900/172.23.100.72.zip

      Attachments

        1. 1030_avg_response_size.png
          1030_avg_response_size.png
          45 kB
        2. 1030_query_requests.png
          1030_query_requests.png
          45 kB
        3. 1227_avg_response_size.png
          1227_avg_response_size.png
          45 kB
        4. 1227_query_requests.png
          1227_query_requests.png
          43 kB
        5. 7.1.0-1030.png
          7.1.0-1030.png
          29 kB
        6. 7.1.0-1227.png
          7.1.0-1227.png
          26 kB
        7. Screen Shot 2021-08-30 at 6.21.08 PM.png
          Screen Shot 2021-08-30 at 6.21.08 PM.png
          111 kB
        8. sear_172.23.100.55_n1ql_cpu_544c11.pprof
          91 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            abhinav Abhi Dangeti
            jyotsna.nayak Jyotsna Nayak
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty