The world's most popular open source database
Some database objects such as tables and indexes have different
limitations when using the NDBCLUSTER storage
engine:
Identifiers.
Database names, table names and attribute names cannot be
as long in NDB tables as when using
other table handlers. Attribute names are truncated to 31
characters, and if not unique after truncation give rise
to errors. Database names and table names can total a
maximum of 122 characters. In other words, the maximum
length for an NDB table name is 122
characters, less the number of characters in the name of
the database of which that table is a part.
Table names containing special characters.
NDB tables whose names contain
characters other than letters, numbers, dashes, and
underscores and which are created on one SQL node may not
be discovered correctly by other SQL nodes. (Bug#31470)
Number of tables and other database objects.
The maximum number of tables in a Cluster database in
MySQL 5.0 is limited to 1792. The maximum
number of all
NDBCLUSTER database objects in a single
MySQL Cluster — including databases, tables, and
indexes — is limited to 20320.
Attributes per table. The maximum number of attributes (that is, columns and indexes) per table is limited to 128.
Attributes per key. The maximum number of attributes per key is 32.
Row size.
The maximum permitted size of any one row is 8KB. Note
that each BLOB or
TEXT column contributes 256
+ 8 = 264 bytes towards this total.


User Comments
Add your own comment.