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
          Pavel Paulau
        2. ddoc-A.node-58.json
          10 kB
          Pavel Paulau
        3. ddoc-A.node-61.json
          10 kB
          Pavel Paulau
        4. ddoc-A.node-63.json
          10 kB
          Pavel Paulau
        5. ddoc-A.node-64.json
          10 kB
          Pavel Paulau
        6. ddoc-B.node-58.json
          10 kB
          Pavel Paulau
        7. ddoc-B.node-61.json
          10 kB
          Pavel Paulau
        8. ddoc-B.node-63.json
          10 kB
          Pavel Paulau
        9. ddoc-B.node-64.json
          10 kB
          Pavel Paulau
        10. ddoc-C.node-58.json
          10 kB
          Pavel Paulau
        11. ddoc-C.node-61.json
          10 kB
          Pavel Paulau
        12. ddoc-C.node-63.json
          10 kB
          Pavel Paulau
        13. ddoc-C.node-64.json
          10 kB
          Pavel Paulau
        14. diag.58.tar.gz
          1.13 MB
          Pavel Paulau
        15. diag.61.tar.gz
          1.13 MB
          Pavel Paulau
        16. diag.63.tar.gz
          1.14 MB
          Pavel Paulau
        17. diag.64.tar.gz
          1.14 MB
          Pavel Paulau
        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
          Pavel Paulau
        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
          Pavel Paulau
        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
          Pavel Paulau
        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
          Pavel Paulau
        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
          Pavel Paulau
        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
          Pavel Paulau
        24. evperf2-4-cap.loop_2.0.0-1916_run_1_Oct-31-2012_16-08-25.pdf
          8.14 MB
          Pavel Paulau
        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
          Pavel Paulau
        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