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

Analytics incr. ingestion 60% slower on 7.6 vs 7.2.4 with default collection

    XMLWordPrintable

Details

    • Triaged
    • 0
    • Yes
    • March-June 24

    Description

      For 7.6.0 release we ran our "P1" performance tests on all components. These tests don't get ran every week like "P0" tests. We observe 60% lower incremental ingestion rate with 7.6 vs 7.2.4 in the following P1 test that uses the default collection:

      Avg. incremental ingestion rate (items/sec), 4 nodes, BigFUN 20M users (320M docs), 3 indexes, SSD

      http://showfast.sc.couchbase.com/#/timeline/Linux/analytics/sync/Incremental#bigfun_20M_sync_4n_incr_oceanus

      In our other incremental ingestion tests (see them all here), 7.6.0 is only ~20% worse than 7.2.4, so this seems significant.

       

      I know 7.5 is in the middle there but I'm not sure its a good baseline to compare to because 7.5 also did very poorly in our ingestion tests with lots of collections (like this one), whereas 7.2.4 behaves more similarly to 7.6.0 in all other tests. That being said, understanding why 7.5.0 has half the ingestion rate of 7.2.4 might be the first step in understanding what is going on.

       

      Since this was the first time we've ran this test on 7.6.0, I ran with an older 7.6.0 build to start understanding when the performance dropped.

      CB build Ingestion rate (items/sec) Jenkins link cbmonitor link
      7.2.4-7069 559541 oceans/13541 link
      7.6.0-2000 189355 oceans/13543 link
      7.6.0-2176 186569 oceanus/13532 link

      When looking into analytics incremental ingestion, I discovered quite a saga of tickets and efforts to improve ingestion rate when there are lots of collections, which has sometimes been to the detriment of lower collection-count tests. We need to establish whether this performance is expected or not.

      Attachments

        1. MB-61257_7.6_dcp_cbas.png
          47 kB
          Paolo Cocchi
        2. MB-61257_7.2_dcp_cbas.png
          45 kB
          Paolo Cocchi
        3. MB-58742_7.6_kv-trace.png
          39 kB
          Paolo Cocchi
        4. MB-58742_7.2_kv-trace.png
          30 kB
          Paolo Cocchi
        5. image-2024-05-16-18-13-15-160.png
          5 kB
          Daniel Nagy
        6. image-2024-03-21-19-24-02-947.png
          41 kB
          Daniel Nagy
        7. image-2024-03-21-18-55-21-699.png
          41 kB
          Daniel Nagy
        8. image-2024-03-21-18-37-51-540.png
          50 kB
          Daniel Nagy
        9. image-2024-03-21-18-34-08-900.png
          54 kB
          Daniel Nagy
        10. image-2024-03-21-18-28-19-432.png
          38 kB
          Daniel Nagy
        11. image-2024-03-21-17-59-48-149.png
          4 kB
          Daniel Nagy
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Daniel.nagy Daniel Nagy
            Daniel.nagy Daniel Nagy
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty