List:Cluster« Previous MessageNext Message »
From:Karl Kloppenborg Date:September 30 2010 4:50am
Subject:Re: MySQL Cluster -- Table Full
View as plain text  
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

Thread
MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
  • Re: MySQL Cluster -- Table FullAdam Dixon30 Sep
    • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
  • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
    • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
      • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
        • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
          • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
            • Re: MySQL Cluster -- Table FullJohan Andersson30 Sep
              • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
                • Re: MySQL Cluster -- Table FullJohan Andersson30 Sep
                  • Re: MySQL Cluster -- Table FullKarl Kloppenborg1 Oct
                    • Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm1 Oct
                      • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct
                        • Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm7 Oct
                      • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct
                      • Re: MySQL Cluster -- Table FullJon Stephens1 Oct
  • Re: MySQL Cluster -- Table FullMoses28 Apr
    • Re: MySQL Cluster -- Table FullJohan Andersson28 Apr
  • Re: MySQL Cluster -- Table FullMoses6 May
Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm1 Oct
  • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct