opensubscriber
   Find in this group all groups
 
Unknown more information…

c : cluster@lists.mysql.com 10 May 2012 • 3:47AM -0400

NDBCluster Load Data Infile extremely slow
by Scott Sandler

REPLY TO AUTHOR
 
REPLY TO GROUP




I've found that the performance of LOAD DATA INFILE for an NDBCluster is over 130x slower than innodb. I expect it to be slower since it has to insert into multiple nodes and push data over the network, but the performance difference I'm seeing is 20,000 rows per second for innodb vs. 150 rows per second into ndbcluster (with the same schema/hardware/etc.). This slowness is quite a big road block in actually being able to migrate to MySQL cluster.

Here's a pastebin of my config.ini<http://pastebin.com/JhrjdXKH>, and another of my my.cnf<http://pastebin.com/9y1mY7zm>. Are there any parameters I can change or anything I can try to speed up the ndb data loading?

Thanks,

Scott


Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

Related Messages

opensubscriber is not affiliated with the authors of this message nor responsible for its content.