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

[Backport MB-47928 to 7.0.2] Need stat for load on index node calculation for Greedy planner testing

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • No

    Description

      We need a stat for identifying load on any give Index node for deterministically finding the node for new index placement. Currently cbindexplan doesn't give any such stat and it involves calculation with multiple stats. It would be easier if we have the stat that Greedy/SA planner use to determine the exact placement of new index. 

       

      After doing further testing, I found out that cbindexplan also doesn't give correct size estimation with deferred index. Due to this incorrect value expected results don't match with actual implementation.

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-48348
          # Subject Branch Project Status CR V

          Activity

            Build couchbase-server-7.0.2-6651 contains indexing commit f34176c with commit message:
            MB-48348: Improve cbindexplan to return usage ratio of each indexer

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.2-6651 contains indexing commit f34176c with commit message: MB-48348 : Improve cbindexplan to return usage ratio of each indexer

            Validated on 7.0.2-6671.

             

            usageRatio is available from cbindexplan.

            less index_plan.log | grep 'usageRatio\|nodeId'
            			"nodeId": "10.112.205.101:8091",
            			"usageRatio": 0.4778980816496897
            			"nodeId": "10.112.205.102:8091",
            			"usageRatio": 0.32210191835031027

            hemant.rajput Hemant Rajput added a comment - Validated on 7.0.2-6671.   usageRatio is available from cbindexplan. less index_plan.log | grep 'usageRatio\|nodeId' "nodeId": "10.112.205.101:8091", "usageRatio": 0.4778980816496897 "nodeId": "10.112.205.102:8091", "usageRatio": 0.32210191835031027

            People

              hemant.rajput Hemant Rajput
              amit.kulkarni Amit Kulkarni
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty