Partitioning of ndbcluster
Hello, I try to find the partition algorithm of the ndbcluster.
My setup:
CREATE TABLE `test` (
`f1` varchar(3) NOT NULL DEFAULT '000',
`f2` varchar(3) NOT NULL DEFAULT '000',
`f3` varchar(3) NOT NULL DEFAULT '000',
`f4` varchar(3) NOT NULL DEFAULT '000',
`f5` varchar(3) NOT NULL DEFAULT '000',
PRIMARY KEY (`f1`,`f2`,`f3`))
ENGINE=ndbcluster
PARTITION BY KEY (f1, f2)
PARTITIONS 8;
Asking mysql I'm getting information about the partition:
explain partitions select * from test2 where f1='cccc' and f2='aaaa';
+----+-------------+-------+------------+------+
| id | select_type | table | partitions | type | ...
+----+-------------+-------+------------+------+
| 1 | SIMPLE | test2 | p6 | ref | ...
+----+-------------+-------+------------+------+
I have gathered information about the calculation of the partition (md5, modulo of partitions, ...). But I donn't get the pices together.
Can someone show me the way how to calculate the partition?
f1='cccc' and f2='aaaa' => Partition p6
f1='????' and f2='????' => Partition p?
Subject
Views
Written By
Posted
Partitioning of ndbcluster
2619
January 04, 2016 07:29AM
1351
January 05, 2016 11:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.