Re: ERROR 1114 (HY000) at line 1038: The table 'member_attribute' is full

[David Wong]

Satoshi Saito Wrote:
-------------------------------------------------------
> >ERROR 1114 (HY000) at line 1038: The table
> 'member_attribute' is full
> >LOG
> >2008-09-12 13:02:50 INFO -- Node 3: Data usage
> increased to 91%(359042 32K pages of total
> 393216)
> >2008-09-12 13:02:50 INFO -- Node 2: Data usage
> increased to 91%(359180 32K pages of total
> 393216)
> >2008-09-12 13:07:46 INFO -- Node 3: Data usage
> increased to 100%(393216 32K pages of total
> 393216)
> >2008-09-12 13:07:46 INFO -- Node 2: Data usage
> increased to 100%(393216 32K pages of total
> 393216)
>
> It looks like "DataMemory is fulled". Even if your
> system is disk-base-storage, you still need
> DataMemory for some indexes which are not
> hash-type and have to stay in DataMemory.
>
> So I recommend you to check things below.
> 1. Are IndexMemory and DataMemory enough to hold
> your data?
> 2. Is the number of columns less than 128? The
> maximum number of attributes (that is, columns and
> indexes) per table is limited to 128.
>
>
> Saito, Satoshi

Saito,

Thank you for the reply. MY
DataMemory=12288M
IndexMemory=3072M

I got 16G memory on my server, is that not enough?

My column is less then 128. So I don't know what to do? Should I increase my data memory size and indexmemory size? anyone got any more suggestion? Or should just split up the table that is having issues into 2 section to import?