I installed a new mysql cluster on windows (for evaluation). I created a table using command below. After I insert just over 1 million records into the table it gives me the "table datadump is full" exception. I have plenty of hard disk space and ram free, and 1 million records is well below the max number of rows for the table. Also the MySql RAm usage has not increased during inserts. I am assuming that MySql has an internal cache limit for the table that was hit. is there a config.ini change I can make to disable caching of rows in cluster table or a modification to the create table script to do the same?
create table datadump (name varchar(30) not null) engine=ndb;
Best Answer
Here is the MySQL Documentation FAQ on MySQL Cluster that addresses your question
Based on the 3rd paragraph, you should run the create table with max_rows: