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

query throughput 50% lower for 1000 collections

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 7.0.0
    • Cheshire-Cat
    • fts
    • Untriaged
    • Centos 64-bit
    • 1
    • Unknown

    Description

      In 1s1c test case we load 1M docs into a single collection and build single index on that collection. In 1s1000c we load the same set and number of docs but split evenly across 1000 collections, then build a single index on those 1000 collections. In both test cases, the queries target the single index with the same query.

      http://showfast.sc.couchbase.com/#/timeline/Linux/jts/1M/Throughput

      Average Throughput (q/sec), AndHighHigh, 10K KV w/sec, wiki 1M x 1KB, 3 node, FTS, s=1 c=1

      http://perf.jenkins.couchbase.com/job/atlas_collections/215/consoleFull

      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-atlas_collections-215/172.23.99.211.zip

      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-atlas_collections-215/172.23.99.39.zip

      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-atlas_collections-215/172.23.99.40.zip

      Throughput - 1240

      Average Throughput (q/sec), AndHighHigh, 10K KV w/sec, wiki 1M x 1KB, 3 node, FTS, s=1 c=1000

      http://perf.jenkins.couchbase.com/job/atlas_collections/217/consoleFull

      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-atlas_collections-217/172.23.99.211.zip

      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-atlas_collections-217/172.23.99.39.zip

      https://s3-us-west-2.amazonaws.com/perf-artifacts/jenkins-atlas_collections-217/172.23.99.40.zip

      Throughput - 660

      Comparison graphs:

      http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=fts_700-4502_run_test_a98f&label=1s1c&snapshot=fts_700-4502_run_test_1f26&label=1s1000c

      Attachments

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

        Activity

          People

            korrigan.clark Korrigan Clark (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty