Re: What's means Table is full? - Mikael Ronström - com.mysql.lists.cluster

4 messages in com.mysql.lists.clusterRe: What's means Table is full?

From	Sent On	Attachments
NiCK	06 Jan 2005 19:18
Mikael Ronström	07 Jan 2005 06:10
Nupur Jain	12 Jan 2005 15:31
Mikael Ronström	12 Jan 2005 15:58

Subject:	Re: What's means Table is full?
From:	Mikael Ronström (mik...@mysql.com)
Date:	01/07/2005 06:10:09 AM
List:	com.mysql.lists.cluster

Hi,

2005-01-07 kl. 04.18 skrev NiCK:

Hi experts,

I made 1 node mysql cluster, just have 1 talble. Appear "ERROR 1114 (HY000) at line 67: The table 'hua_user' is full" when insert 8000000 rows record via mysqldump file.Then I perform "select count(*) from hua_user." just 137797 rows record have been inserted into the table. I was checking partition space which store mysql cluster data have 11G left.I was perfroming top , the top process as following:

MySQL Cluster stores data in memory with checkpointing to disk. So when this error comes up it is out of memory in ndbd process which is the problem. You probably need a very big memory to handle your data since already 138k records fill up your 128M of DataMemory (=> 8M records need about 7.2G of DataMemory and you also need a bigger IndexMemory to handle 8M records, probably around 400 MByte should be ok with some safety margin).

If my assumptions are correct your hua_user table should be around 900 bytes per record.

Rgrds Mikael

10594 root 15 0 438M 163M 800 D 0.0 43.7 0:48 0 ndbd The process stat "D" . My config.ini as following: [NDBD DEFAULT] NoOfReplicas= 1 DataMemory = 128M IndexMemory = 64M MaxNoOfConcurrentOperations = 250000

[MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT]

[NDB_MGMD] HostName= 192.168.8.91

[NDBD] HostName= 192.168.8.91 DataDir= /home/mysql/mysql-cluster

[MYSQLD] [MYSQLD] [MYSQLD]

And my question why the mysql error table is full?

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