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

            amit.kulkarni Amit Kulkarni created issue -
            amit.kulkarni Amit Kulkarni made changes -
            Field Original Value New Value
            Link This issue Clones MB-47928 [ MB-47928 ]
            amit.kulkarni Amit Kulkarni made changes -
            Fix Version/s 7.0.2 [ 18012 ]
            Fix Version/s Neo [ 17615 ]
            jeelan.poola Jeelan Poola made changes -
            Link This issue blocks MB-46308 [ MB-46308 ]
            amit.kulkarni Amit Kulkarni made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]

            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
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Assignee Amit Kulkarni [ amit.kulkarni ] Hemant Rajput [ hemant.rajput ]

            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
            hemant.rajput Hemant Rajput made changes -
            Status Resolved [ 5 ] Closed [ 6 ]

            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