4 messages in com.mysql.lists.clusterDataMemory and IndexMemory
FromSent OnAttachments
Jesse Erlbaum30 Jan 2005 17:36 
Stewart Smith30 Jan 2005 17:57 
Jesse Erlbaum30 Jan 2005 18:12 
Stewart Smith30 Jan 2005 19:17 
Subject:DataMemory and IndexMemory
From:Jesse Erlbaum (jes@erlbaum.net)
Date:01/30/2005 05:36:38 PM
List:com.mysql.lists.cluster

Hi All --

Trying to load a database into the MySQL cluster tonight I got the following:

ERROR 1114 (HY000) at line 500442: The table 'wordmatch' is full

This message kicked out after about 430k rows of a 620k row table loaded. After digging around a bit, I found that this appears to be a current short-coming of the MySQL cluster. Is that correct?

I read the page at:

http://dev.mysql.com/doc/mysql/en/mysql-cluster-db-definition.html

One thing which was not clear to me: Is it necessary to have sufficient RAM to load the *entire* database into memory, or just enough RAM for the largest likely transaction?

Thanks,

-Jesse-