26 messages in com.mysql.lists.clusterRE: table full error?
FromSent OnAttachments
Crouch, Luke H.29 Jul 2004 13:36 
Mikael Ronström29 Jul 2004 13:57 
Crouch, Luke H.29 Jul 2004 14:29 
Mikael Ronström29 Jul 2004 14:46 
Crouch, Luke H.29 Jul 2004 15:07 
Mikael Ronström29 Jul 2004 15:28 
Crouch, Luke H.30 Jul 2004 06:40 
Mikael Ronström30 Jul 2004 07:08 
Crouch, Luke H.30 Jul 2004 07:25 
Mikael Ronström30 Jul 2004 08:23 
Crouch, Luke H.30 Jul 2004 08:36 
pek...@mysql.com31 Jul 2004 02:41 
Crouch, Luke H.31 Jul 2004 08:27 
pek...@mysql.com01 Aug 2004 03:09 
Sundeep Narravula01 Aug 2004 03:32 
pek...@mysql.com01 Aug 2004 03:50 
Crouch, Luke H.02 Aug 2004 06:29 
pek...@mysql.com02 Aug 2004 06:42 
Crouch, Luke H.03 Aug 2004 08:23 
Mikael Ronström04 Aug 2004 03:38 
Crouch, Luke H.04 Aug 2004 06:15 
Mikael Ronström04 Aug 2004 06:34 
Crouch, Luke H.04 Aug 2004 08:54 
Mikael Ronström04 Aug 2004 10:31 
Crouch, Luke H.04 Aug 2004 10:38 
Mikael Ronström04 Aug 2004 10:57 
Subject:RE: table full error?
From:Crouch, Luke H. (Luke@red-man.com)
Date:07/29/2004 03:07:29 PM
List:com.mysql.lists.cluster

Mikael,

the table has 4 million records, each about 100 bytes, and no primary key (doh!)

could that be part of our problem? this doesn't seem like an unusually large
table...do you think the default values would be able to handle a table this
size? could it be something else other than these memory settings?

thanks, -L

-----Original Message----- From: Mikael Ronström [mailto:mik@mysql.com] Sent: Thursday, July 29, 2004 4:47 PM To: Crouch, Luke H. Cc: Vinay Joosery; clus@lists.mysql.com Subject: Re: table full error?

Hi Luke, I am referring to the MySQL Manual available on http://dev.mysql.com/doc/mysql/en/index.html where chapter 17 is dedicated to MySQL Cluster. This page is updated immediately as changes are done in the manual.

To set a parameter to 300 MByte you write 300M as an example.

The cluster administration guide is a useful resource still but it is not updated so the manual contains the "latest and the greatest".

Rgrds Mikael

2004-07-29 kl. 23.30 skrev Crouch, Luke H.:

Mikael,

what manual are you referencing? the mysql cluster administration guide that I have has the parameters NoOfIndexPages and NoOfDataPages for DB definitions, with a unit of 8KB pages. what unit is the DataMemory and IndexMemory parameters expressed in? kB?

is there a kind of 'live' manual available online? where can we get the most recent manual each day?

thanks, -L

-----Original Message----- From: Mikael Ronström [mailto:mik@mysql.com] Sent: Thursday, July 29, 2004 3:58 PM To: Crouch, Luke H. Cc: Vinay Joosery; clus@lists.mysql.com Subject: Re: table full error?

Hi Luke, Most likely DataMemory and IndexMemory from your short description. Check the manual for more details on how to set it. Default is DataMemory size of 80000 kBytes sounds reasonable if your records are about 60-70 bytes. IndexMemory is by default set to 24000 kBytes so it is reasonable that this parameter is your problem if you have a 4 byte primary key.

Rgrds Mikael

2004-07-29 kl. 22.36 skrev Crouch, Luke H.:

we are trying to load up an NDB table thru one of the API nodes. we have a file (generated by a mysqldump) that inserts 4 million records, but when we run it, it stops at about 996k and says table is full! where is the setting that controls this?

thanks, -L

-- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=mik@mysql.com

Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com

Clustering: http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html

http://www.eweek.com/article2/0,1759,1567546,00.asp