MySQL Forums
Forum List  »  NDB clusters

Very slow inserts rate with two concurrent connections
Posted by: Yakov Becker
Date: March 22, 2012 11:16AM

I just setup my first mysql cluster. It has three data nodes and three mysqld nodes running on three servers. Each server runs data and mysqld pair.

I test it with simple java application that makes inserts of 100 record batches to the single table in loop. I am getting 376 inserted rows per second when I run one thread. It is relatively slow comparing to 1874 records per second I got with single MySQL (not cluster) with InnoDB running on the same server with the same test. But my main problem is major (down to 25 records per second) throughput degradation when I add just one additional thread with it's own dedicated connection (running two threads in parallel with connection per thread).

Why is that?

Options: ReplyQuote


Subject
Views
Written By
Posted
Very slow inserts rate with two concurrent connections
1638
March 22, 2012 11:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.