Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
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
- includes
-
MDEV-31787 Clean up and code documentation of casual_read related code
-
- Closed
-
- relates to
-
MDEV-31788 Factor out code repeat in functions calling spider_check_and_init_casual_read()
-
- Closed
-
-
MDEV-31789 Deprecate spider_casual_read
-
- Closed
-
- blocks
-
DOCS-2909 Failed to load
- is duplicated by
-
DOCSCOLLAB-170 Failed to load
- is parent of
-
DOCSCOLLAB-682 Loading...
Activity
Field | Original Value | New Value |
---|---|---|
Assignee | Ian Gilfillan [ greenman ] | Nayuta Yanagisawa [ JIRAUSER47117 ] |
Fix Version/s | N/A [ 14700 ] | |
Fix Version/s | 10.4 [ 22408 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | Stalled [ 10000 ] |
Assignee | Nayuta Yanagisawa [ JIRAUSER47117 ] | Jacob Moorman [ jacob.moorman ] |
Epic Link | MENT-51 [ 75581 ] |
Link | This issue is part of MENT-51 [ MENT-51 ] |
Epic Link | MENT-51 [ 75581 ] |
Assignee | Jacob Moorman [ jacob.moorman ] | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] |
Workflow | MariaDB v3 [ 123465 ] | MariaDB v4 [ 131749 ] |
Assignee | Ralf Gebhardt [ ralf.gebhardt@mariadb.com ] | Nayuta Yanagisawa [ JIRAUSER47117 ] |
Assignee | Nayuta Yanagisawa [ JIRAUSER47117 ] | Geoff Montee [ geoffmontee ] |
Assignee | Geoff Montee [ geoffmontee ] | Anne Strasser [ annestrasser ] |
Remote Link | This issue links to "DOCSCOLLAB-170 (Jira (Corp))" [ 34944 ] |
Remote Link | This issue links to "DOCSCOLLAB-682 (Jira)" [ 34984 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Remote Link | This issue links to "DOCS-2909 (Jira)" [ 35403 ] |
Assignee | Anne Strasser [ annestrasser ] | Yuchen Pei [ JIRAUSER52627 ] |
Priority | Major [ 3 ] | Critical [ 2 ] |
Link |
This issue includes |
Link |
This issue relates to |
Link |
This issue relates to |
Assignee | Yuchen Pei [ JIRAUSER52627 ] | Anne Strasser [ annestrasser ] |
Assignee | Anne Strasser [ annestrasser ] | Yuchen Pei [ JIRAUSER52627 ] |
Status | In Progress [ 3 ] | Stalled [ 10000 ] |
Assignee | Yuchen Pei [ JIRAUSER52627 ] | Anne Strasser [ annestrasser ] |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Link | This issue is part of MENT-51 [ MENT-51 ] |
Zendesk Related Tickets | 171280 |