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

Throughput of composite queries with TOKENS() dropped from ~24K to ~4K queries/sec

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 5.0.0
    • 5.0.0
    • secondary-index
    • 4 data nodes, 1 query node, 1 index node (moi)

    Description

      Index:

      CREATE INDEX tokens_idx ON `bucket-1`(address.zip, DISTINCT ARRAY s FOR s IN TOKENS(address.street) END);


      SELECT first_name, last_name, address FROM `bucket-1` WHERE address.zip = $1 AND ANY s IN TOKENS(address.street) SATISFIES s = $2 END;

      http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=iris_500-1955_access_7bca&snapshot=iris_500-2030_access_7c2e

      Attachments

        1. cpu_flame.svg
          344 kB
        2. cpu.svg
          125 kB
        3. q14.png
          q14.png
          108 kB

        Issue Links

          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

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

          Activity

            People

              pavelpaulau Pavel Paulau (Inactive)
              pavelpaulau Pavel Paulau (Inactive)
              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