Some database objects such as tables and indexes have different
limitations when using the
NDBCLUSTER storage engine:
Database and table names. When using the
NDBstorage engine, the maximum allowed length both for database names and for table names is 63 characters. A statement using a database name or table name longer than this limit fails with an appropriate error.
Number of database objects. The maximum number of all
NDBdatabase objects in a single NDB Cluster—including databases, tables, and indexes—is limited to 20320.
Attributes per table. The maximum number of attributes (that is, columns and indexes) that can belong to a given table is 512.
Attributes per key. The maximum number of attributes per key is 32.
BIT column storage per table. The maximum combined width for all
BITcolumns used in a given
NDBtable is 4096.
FIXED column storage. NDB Cluster 7.5 and later supports a maximum of 128 TB per fragment of data in
FIXEDcolumns. (Previously, this was 16 GB.)