MySQL Performance: MySQL => MySQL Cluster insert performance.

Members

Help

Home

Home » Performance » MySQL » MySQL Cluster insert performance.

Show: Today's Messages :: Show Polls :: Message Navigator

MySQL Cluster insert performance. [message #1025]

Tue, 03 April 2007 18:47

linuxninja39
Messages: 1
Registered: April 2007
Location: Utah

Junior Member

I am currently trying to build a table that will hold several billion rows small rows of data. From the info mysql cluster seems to be the way to go. However I am doing some testing and inserts into my set up are painfully slow. I have 4 2.4G Xeon 1G boxes.

If I create my table using myism I can insert a million rows in about 1 min. However if I use the ndbcluster engine, the same script take more than 15min to insert 1 million rows. I am on a GIG network.

Any suggestions on how to optimize these inserts would be very helpful.

Report message to a moderator

Previous Topic:	IN(...) ORDER BY ...
Next Topic:	MYSQL goes very slow after every 4-5 hours

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 18:18:21 EDT 2009

Total time taken to generate the page: 0.02295 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.