Hi Fabricio!
Have you tried increasing the DataMemory for the storage nodes in the
configuration file?
Since MySQL Cluster currently stores all tables in main-memory the
default settings are
pretty conservative.
BR
-- Martin
Fabricio Silva wrote:
>Hi all,
>
>I'm testing MySQL Cluster with a database about 1 Gbytes and I noticed
>some strange things.
>
>Firstly I create the table like:
>
>create table customer ( c_custkey integer not null,
> c_name varchar(25) not null,
> c_address varchar(40) not null,
> c_nationkey integer not null,
> c_phone char(15) not null,
> c_acctbal decimal(15,2) not null,
> c_mktsegment char(10) not null,
> c_comment varchar(117) not null)
>engine=ndbcluster;
>
>I'm using some text files to feed the tables. So in mysql I use the command:
>
>LOAD DATA INFILE '/home/.../customer.tbl' INTO TABLE customer FIELDS
>TERMINATED BY '|' (for example).
>
>And with some tables (customer too) an error appears saying that the
>table is FULL.
>
>I tryed to do this with single MySQL installation (without NDBCLUSTER
>configuration) and I could insert all the text files on all tables
>without problems.
>
>Does anyone know why I have this error when I'm using MySQL Cluster?
>MySQL Cluster has more limitations the MySQL without NDBCLUSTER
>configuration??
>
>Please help me!!!!
>
>It's really important I know this!!!
>
>
>Thanks a lot!!
>
>Fabrício
>
>
>
--
Martin Sköld, Software Engineer
MySQL AB, www.mysql.com
Office: +46 (0)730 31 26 21
