you need to increase your DataMemory and IndexMemory parameters. the defaults are 80M and
24M, respectively...
in your config.ini...
[DB DEFAULT]
DataMemory: 500M
IndexMemory: 100M
when you do this, however...I think you may want to start the nodes with -i option. and
re-load the data again. Mikael can tell you for sure, though.
-L
> -----Original Message-----
> From: kasandra Padisha [mailto:kasandra@stripped]
> Sent: Wednesday, September 15, 2004 4:20 PM
> To: cluster@stripped
> Subject: NDBCluster: Table is full
>
>
>
> Hi
>
> I have a cluster running using mysql-4.1.4a-gamma, on debians 3.0
> stable. It has a master (MGM), two DBs and two (API). I included
> the config.ini file at the end.
>
> It works pretty well, we have test it all, from one API, from the
> other, the sync works OK, .. everything looking good
>
> ..but now we are starting to load it with a big amount of
> information and we start to have the message:
>
> ERROR 1114 at line 2: The table 'aaaaa' is full
>
> We are running an script that loads lot of information, and
> in some places it stops with this message, and it is not
> always. We tried to do it by hand, with the tables in trouble,
> and it lets to insert one row at a time, but with two it did not.
>
> We tried to increase the max rows as it is shown in the
> manual Sect A.2.11 (of course it is for myisam but we gave
> it a go) .. but we got an error
>
> ALTER table aaa MAX_ROWS=10000000 AVG_ROW_LENGTH=1039335076;
>
> and returned
> ERROR 1005 (HY000): Can't create table
> './cdr/#sql-4a98_10f.frm' (errno:
> 4336)
>
> strange .. ... Any clue somebody ???
>
> --------------------------------------- config.ini ---------------
> [DB DEFAULT]
> NoOfReplicas: 2
>
> [COMPUTER]
> Id: 1
> HostName: mgm
>
> [COMPUTER]
> Id: 2
> HostName: proc1
>
> [COMPUTER]
> Id: 3
> HostName: proc2
>
> [MGM]
> Id: 1
> ExecuteOnComputer: 1
>
> [DB]
> Id: 2
> ExecuteOnComputer: 2
> FileSystemPath: /var/mysql/ndb/data
>
> [DB]
> Id: 3
> ExecuteOnComputer: 3
> FileSystemPath: /var/mysql/ndb/data
>
> [API]
> Id: 4
> ExecuteOnComputer: 2
>
> [API]
> Id: 5
> ExecuteOnComputer: 3
>
> [TCP DEFAULT]
> PortNumber: 10002
> ---------------------------------------------------
>
>
> --
> _____________________________________________________________
> Web-based SMS services available at http://www.operamail.com.
> From your mailbox to local or overseas cell phones.
>
> Powered by Outblaze
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
http://lists.mysql.com/cluster?unsub=1
