Hi,
Speed up can be achieved in 3 dimensions.
1) More than 1 insert per INSERT statement
Every doubling here will give about 50% better speed up to around 100 records.
2) Insert in several connections on the same server in parallel.
3) Insert in parallel on several servers in parallel.
It should be possible to get to at least around 100.000 records/second if you use
all those measures to speed up.
Rgrds Mikael
Anton Aleksandrov wrote:
> hi,
> I've got table with 2.2mln records. When I try to
> delete all of them, I get an error: "ERROR 1296
> (HY000): Got error 4350 'Transaction already
> aborted' from ndbcluster. I tried that in both
> single and multi user mode.
>
> An one more thing.. I am trying to import big
> database (about 17mln records in total), but it
> takes really long time to go with speed just
> 3-5Mbit, although I've got Gbit lan there. Does
> anyone know why? and how can I speed it up? I have
> 8 db nodes, but try to insert into API node, which
> is different server.
>
> Anton
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com