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

Observing greater than ~11% drop in transaction throughput between 1 collection vs 1000 collections with durability level greater than majority

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown
    • KV-Engine 2021-March

    Description

      Observing ~18 to 20% drop in kv_transactions throughput between single collection vs 1000 collections .

      http://showfast.sc.couchbase.com/#/timeline/Linux/kv/transaction/Throughput

      Comparison tests - 

       

      Avg Throughput (trans/sec), Workload T, 4 nodes, Majority_Persist_Active, 12 vCPU, s=1 c=1000, worker_instance=1

      vs

      Avg Throughput (trans/sec), Workload T, 4 nodes, Majority_Persist_Active, 12 vCPU, s=1 c=1, worker_instance=1

       

       
      Test 

      sl no no  of collections Throughput (trans/sec) avg cpu link
      1 1 376 ~22% http://perf.jenkins.couchbase.com/job/hercules-txn/1326/
      2 1000 330 ~28% http://perf.jenkins.couchbase.com/job/hercules-txn/1313/

       

      stats comparison

      http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=hercules_700-4617_access_a404&label=1000collection&snapshot=hercules_700-4617_access_6c6d&label=1collection

       

       

      Avg cpu utilization in case of 1000 collections is significantly higher compared to single collection .

       

                                            java client side cpu comparison

       

      It's known that we have seen about ~6% drop in kv throughput with large number of collections (mostly to sanitize incoming collections in each operation) MB-39594.

      However trend seen in case of kv_collections seem to be alarming considering degradation is quite indeterministic across different durability levels .

      *I will share consolidated comparison across different durability levels soon .

       

       

      Attachments

        Issue Links

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

          Activity

            People

              sharath.sulochana Sharath Sulochana (Inactive)
              sharath.sulochana Sharath Sulochana (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty