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

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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            Created back port ticket to 7.0.2

            amit.kulkarni Amit Kulkarni added a comment - Created back port ticket to 7.0.2

            Build couchbase-server-7.1.0-1260 contains indexing commit 1428812 with commit message:
            MB-47928: Improve cbindexplan to return usage ratio of each indexer

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1260 contains indexing commit 1428812 with commit message: MB-47928 : Improve cbindexplan to return usage ratio of each indexer

            Validated on 7.1.0-1986

             

            /opt/couchbase/bin/cbindexplan  -command=retrieve -cluster="127.0.0.1:8091" -username="Administrator" -password="password" -getUsage -numNewReplica 1 -output /tmp/index_plan.log
            lfc@LFCs-MacBook-Pro testrunner % less index_plan.log | grep 'usageRatio\|nodeId'
            "nodeId": "10.112.205.101:8091",
            "usageRatio": 0.600464214334424
            "nodeId": "10.112.205.102:8091",
            "usageRatio": 0
            "nodeId": "10.112.205.103:8091",
            "usageRatio": 0.5995357856655761
            lfc@LFCs-MacBook-Pro testrunner % 
             
            
            

            hemant.rajput Hemant Rajput added a comment - Validated on 7.1.0-1986   /opt/couchbase/bin/cbindexplan  -command=retrieve -cluster="127.0.0.1:8091" -username="Administrator" -password="password" -getUsage -numNewReplica 1 -output /tmp/index_plan.log lfc@LFCs-MacBook-Pro testrunner % less index_plan.log | grep 'usageRatio\|nodeId' "nodeId": "10.112.205.101:8091", "usageRatio": 0.600464214334424 "nodeId": "10.112.205.102:8091", "usageRatio": 0 "nodeId": "10.112.205.103:8091", "usageRatio": 0.5995357856655761 lfc@LFCs-MacBook-Pro testrunner %   

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty