Hi Adam,
This is the current status from each node (also one other nodes is rebuilding as we
speak!)
ndb_mgm> all report mem
Connected to Management Server at: localhost:1186
Node 3: Data usage is 5%(224273 32K pages of total 4259840)
Node 3: Index usage is 42%(279825 8K pages of total 655392)
Node 4: Data usage is 2%(116118 32K pages of total 4259840)
Node 4: Index usage is 15%(164455 8K pages of total 1048608)
ndb_mgm>
I am struggling to see how this is indeed out of memory?
Could you maybe explain to me how we could log this and then find out actually what is
going on? because as you know "Table full" its a bit obvious!
Cheers,
Karl.
On 30/09/2010, at 14:43, Adam Dixon wrote:
> Hi,
>
> On Thu, Sep 30, 2010 at 1:45 PM, Karl Kloppenborg <karl@stripped> wrote:
> ...
>> However at 92Million rows in a table, it is returning the TableFull error?
> ...
>> DataMemory=131G
>> IndexMemory=10G
>
> Depending on the storage requirements of your table containing the 92m
> rows - it could well be that you are indeed out of memory.
>
> Your ndb_mgmd's should have log files perhaps printing your data/index
> memory usage fairly periodically. Can you provide this info?
>
> Adam
