List:Cluster« Previous MessageNext Message »
From:Andrew Hutchings Date:November 4 2009 10:28am
Subject:RE: Send Buffers overloaded in NDB kernel
View as plain text  
Hello Matthew,

On Tue, 2009-11-03 at 10:03 -0600, Boehm, Matthew wrote:
> A benchmarking application wouldn't produce good results if it had to
> "do again". Basically this shows that cluster cannot handle 256 threads
> of "update non-index" style SQL.

Not quite, it shows your configuration cannot handle this.  Cluster is
not designed to perform well doing this but it can be done.  I suggest
increasing the 6M hard limit you have set on the Send and Receive
buffers (or removing them completely so the dynamic
TotalSendBufferMemory can be used).  Especially if you are using ndbmtd.

Kind Regards
-- 
Andrew Hutchings, MySQL Support Engineer, Americas
Sun Microsystems, United Kingdom
http://www.sun.com/mysql/

Thread
Send Buffers overloaded in NDB kernelMatthew Boehm3 Nov 2009
  • Re: Send Buffers overloaded in NDB kernelPekka Nousiainen3 Nov 2009
    • RE: Send Buffers overloaded in NDB kernelMatthew Boehm3 Nov 2009
      • RE: Send Buffers overloaded in NDB kernelAndrew Hutchings4 Nov 2009
        • RE: Send Buffers overloaded in NDB kernelMatthew Boehm10 Nov 2009
          • Re: Send Buffers overloaded in NDB kernelPekka Nousiainen10 Nov 2009
            • RE: Send Buffers overloaded in NDB kernelMatthew Boehm10 Nov 2009
              • Re: Send Buffers overloaded in NDB kernelPekka Nousiainen10 Nov 2009
                • RE: Send Buffers overloaded in NDB kernelMatthew Boehm10 Nov 2009
                  • Re: Send Buffers overloaded in NDB kernelJonas Oreland10 Nov 2009
                    • RE: Send Buffers overloaded in NDB kernelMatthew Boehm10 Nov 2009
                      • RE: Send Buffers overloaded in NDB kernelMatthew Boehm11 Nov 2009
                • RE: Send Buffers overloaded in NDB kernelMatthew Boehm10 Nov 2009
              • Re: Send Buffers overloaded in NDB kernelRobert Klikics11 Nov 2009
                • RE: Send Buffers overloaded in NDB kernelMatthew Boehm11 Nov 2009
                  • Re: Send Buffers overloaded in NDB kernelRobert Klikics11 Nov 2009
                    • RE: Send Buffers overloaded in NDB kernelMatthew Boehm11 Nov 2009
                      • Re: Send Buffers overloaded in NDB kernelRobert Klikics11 Nov 2009
                        • RE: Send Buffers overloaded in NDB kernelMatthew Boehm11 Nov 2009
                        • Re: Send Buffers overloaded in NDB kernelPekka Nousiainen11 Nov 2009
                          • Re: Send Buffers overloaded in NDB kernelRobert Klikics11 Nov 2009