If you need to create a big database into MySQL Cluster
with:
- A lot of tables indexes, columns, and tables
- A lot of records
there are a few things to think about:
- 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 table object. …