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

query performance degrades over time on spinning HDD

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 2.0
    • 2.0-beta
    • view-engine
    • Security Level: Public
    • Physical machines (terra cluster, CentOS 5.8, 32GB RAM, 4 cores, 2xSATA disks, dedicated ethernet switch)

    Description

      That was observed at least in two cases.
      #1: long large scale view performance test, build 1505
      https://raw.github.com/couchbase/testrunner/master/conf/perf/evperf2-3.conf

      #2: show low-scale view performance test, build 1530
      https://raw.github.com/couchbase/testrunner/master/conf/perf/lucky8.conf

      In both cases data size doesn't grow significantly. See attached reports for details.

      See also this conversation:
      https://www.yammer.com/couchbase.com/#/Threads/show?threadId=198629425

      Attachments

        1. btree_stats.tar
          160 kB
        2. ddoc-A.node-58.json
          10 kB
        3. ddoc-A.node-61.json
          10 kB
        4. ddoc-A.node-63.json
          10 kB
        5. ddoc-A.node-64.json
          10 kB
        6. ddoc-B.node-58.json
          10 kB
        7. ddoc-B.node-61.json
          10 kB
        8. ddoc-B.node-63.json
          10 kB
        9. ddoc-B.node-64.json
          10 kB
        10. ddoc-C.node-58.json
          10 kB
        11. ddoc-C.node-61.json
          10 kB
        12. ddoc-C.node-63.json
          10 kB
        13. ddoc-C.node-64.json
          10 kB
        14. diag.58.tar.gz
          1.13 MB
        15. diag.61.tar.gz
          1.13 MB
        16. diag.63.tar.gz
          1.14 MB
        17. diag.64.tar.gz
          1.14 MB
        18. evperf2-1.loop_2.0.0-1692-rel-enterprise_2.0.0-1692-rel-enterprise_run_1_Sep-07-2012_18-37-10.pdf
          6.46 MB
        19. evperf2-1.loop_2.0.0-1746-rel-enterprise_2.0.0-1746-rel-enterprise_run_1_Sep-24-2012_16-51-02.pdf
          2.54 MB
        20. evperf2-1.loop_2.0.0c-704-rel-community_2.0.0c-704-rel-community_run_1_Aug-19-2012_05-55-48.pdf
          2.61 MB
        21. evperf2-3.loop_2.0.0-1505-rel-enterprise_2.0.0-1505-rel-enterprise_run_1_Aug-02-2012_09-09-21.pdf
          5.49 MB
        22. evperf2-4.loop_2.0.0-1792-rel-enterprise_2.0.0-1792-rel-enterprise_run_1_Oct-04-2012_12-45-06.pdf
          6.77 MB
        23. evperf2-4.loop_2.0.0-1858-rel-enterprise_2.0.0-1858-rel-enterprise_run_1_Oct-19-2012_17-24-11.pdf
          7.83 MB
        24. evperf2-4-cap.loop_2.0.0-1916_run_1_Oct-31-2012_16-08-25.pdf
          8.14 MB
        25. lucky8.loop_2.0.0-1530-rel-enterprise_2.0.0-1530-rel-enterprise_run_1_Aug-02-2012_18-58-05.pdf
          1.51 MB
        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:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty