- A lot of tables indexes, columns, and tables
- A lot of records
- If a table has > ~90M records, you have to create the table with
MAX_ROWS=<amount of records in table anticipating growth>:CREATE TABLE t1(...) ENGINE=ndbcluster MAX_ROWS=200000000;
This way the data node will allocate more partitions for the table, since there is a limitation in how many records that can be stored in one partition (and the limit is around 90M records). - Many tables / table objects --> Make sure you increase
MaxNoOfTables(kernel limit is 20320 tables). This creates a table object pool of sizeMaxNoOfTables.- Each table you create will use one