RE: NDBCluster: Table is full - Crouch, Luke H. - com.mysql.lists.cluster

4 messages in com.mysql.lists.clusterRE: NDBCluster: Table is full

From	Sent On	Attachments
kasandra Padisha	15 Sep 2004 14:19
Crouch, Luke H.	15 Sep 2004 14:45
Tomas Ulin	16 Sep 2004 02:21
Crouch, Luke H.	16 Sep 2004 06:06

Subject:	RE: NDBCluster: Table is full
From:	Crouch, Luke H. (Luke...@red-man.com)
Date:	09/15/2004 02:45:06 PM
List:	com.mysql.lists.cluster

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:kasa...@operamail.com] Sent: Wednesday, September 15, 2004 4:20 PM To: clus...@lists.mysql.com Subject: NDBCluster: Table is full

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.