89415

ndb and userdefined 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:

I.OnlyKEY 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 MaxNoOf ExecutionThreads[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 morę information.

For morę 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".