NDB and user defined partitioning-opracowanie

NDB and user defined partitioning. While MySQL Cluster normally partitions NDB tables
automatically, it is possible to employ user-defined partitioning with NDB tables. This is subject to the
following limitations:
1. Only KEY and LINEAR KEY partitioning schemes can be used with NDB tables.
2. When using ndbd, the maximum number of partitions that may be defined explicitly for any NDB
table is 8 * [number of node groups]. (The number of node groups in a MySQL Cluster is
determined as discussed previously in this section.)
When using ndbmtd, this maximum is also affected by the number of local query handler threads,
which is determined by the value of the MaxNoOfExecutionThreads [2237] configuration
parameter. In such cases, the maxmimum number of partitions that may be defined explicitly for an
NDB table is equal to 4 * MaxNoOfExecutionThreads * [number of node groups].
See Section 17.4.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”, for
more information.
For more information relating to MySQL Cluster and user-defined partitioning, see Section 17.1.6,
“Known Limitations of MySQL Cluster”, and Section 18.6.2, “Partitioning Limitations Relating to Storage
Engines”.
... zobacz całą notatkę