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

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.