Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26151

Documentation on spider_casual_read is insufficient/non-existing

Details

    Description

      It is not clear from this document:

      https://mariadb.com/docs/reference/mdb/cli/mariadbd/spider-casual-read/

      and KB:

      https://mariadb.com/kb/en/spider-server-system-variables/#spider_casual_read

      what is the "connection channel" and what settings should be used and at what level for typical use cases:

      1. The overall data node is 4 nodes and there are two partitions that point to the same data node.

      CREATE TABLE spider (
      :
      ) ENGINE SPIDER PARTITION BY xxx (
      pt1 ... ENGINE SPIDER COMMENT 'srv datanode1' ,
      pt2 ... ENGINE SPIDER COMMENT 'srv datanode1' ,
      pt3 ... ENGINE SPIDER COMMENT 'srv datanode2' ,
      pt4 ... ENGINE SPIDER COMMENT 'srv datanode3' ,
      ptmax ... ENGINE SPIDER COMMENT 'srv datanode4'

      )

      2. Case with four overall data nodes and three partitions pointing to the same data node


      CREATE TABLE spider (
      :
      ) ENGINE SPIDER PARTITION BY xxx (
      pt1 ... ENGINE SPIDER COMMENT 'srv datanode1' ,
      pt2 ... ENGINE SPIDER COMMENT 'srv datanode1' ,
      pt3 ... ENGINE SPIDER COMMENT 'srv datanode1' ,
      pt4 ... ENGINE SPIDER COMMENT 'srv datanode2' ,
      pt5 ... ENGINE SPIDER COMMENT 'srv datanode3' ,
      ptmax ... ENGINE SPIDER COMMENT 'srv datanode4'

      )

      3. Case where the overall data node is 4 nodes and every partition points to a different data node


      CREATE TABLE spider (
      :
      ) ENGINE SPIDER PARTITION BY xxx (
      pt1 ... ENGINE SPIDER COMMENT 'srv datanode1',
      pt2 ... ENGINE SPIDER COMMENT 'srv datanode2',
      pt3 ... ENGINE SPIDER COMMENT 'srv datanode3',
      pt4 ... ENGINE SPIDER COMMENT 'srv datanode4'
      )

      4. Case where all partitions point to a local table


      CREATE TABLE spider (
      :
      ) ENGINE SPIDER PARTITION BY xxx (
      pt1 ... ENGINE InnoDB,
      pt2 ... ENGINE InnoDB,
      pt3 ... ENGINE InnoDB,
      pt4 ... ENGINE InnoDB
      )

      So, can you, please, clarify in the documentation, Enterprise or KB, or both, what value to set for spider_casual_read, and on what level, table or global, for each of these 4 cases?

      Attachments

        Issue Links

          Activity

            valerii Valerii Kravchuk created issue -
            ralf.gebhardt Ralf Gebhardt made changes -
            Field Original Value New Value
            Assignee Ian Gilfillan [ greenman ] Nayuta Yanagisawa [ JIRAUSER47117 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.4 [ 22408 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Nayuta Yanagisawa [ JIRAUSER47117 ] Jacob Moorman [ jacob.moorman ]
            julien.fritsch Julien Fritsch made changes -
            Epic Link MENT-51 [ 75581 ]
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            Epic Link MENT-51 [ 75581 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            Assignee Jacob Moorman [ jacob.moorman ] Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 123465 ] MariaDB v4 [ 131749 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] Nayuta Yanagisawa [ JIRAUSER47117 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Nayuta Yanagisawa [ JIRAUSER47117 ] Geoff Montee [ geoffmontee ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Geoff Montee [ geoffmontee ] Anne Strasser [ annestrasser ]
            julien.fritsch Julien Fritsch made changes -
            AnneStrasser Anne Strasser (Inactive) made changes -
            julien.fritsch Julien Fritsch made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            AnneStrasser Anne Strasser (Inactive) made changes -
            ycp Yuchen Pei made changes -
            Assignee Anne Strasser [ annestrasser ] Yuchen Pei [ JIRAUSER52627 ]
            ycp Yuchen Pei made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Anne Strasser [ annestrasser ]
            ycp Yuchen Pei made changes -
            Assignee Anne Strasser [ annestrasser ] Yuchen Pei [ JIRAUSER52627 ]
            ycp Yuchen Pei made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            ycp Yuchen Pei made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Anne Strasser [ annestrasser ]
            ycp Yuchen Pei made changes -
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            julien.fritsch Julien Fritsch made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 171280

            People

              AnneStrasser Anne Strasser (Inactive)
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.