0

I need to insert very large amount of data(over 1 billion rows) to one table.

I used TokuDB as my Database Engine. And I know it supports "Concurrent Insert".

I'm just wondering if I have a very powerful server to host my DB. Does the "Concurrent Insert" improve Insertion speed?

tmcallaghan
  • 1,292
  • 2
  • 10
  • 20
Nick Ren
  • 65
  • 3
  • 10
  • Are you bulk loading this table (using something like "load data infile ...") or inserting via insert statements? – tmcallaghan Jul 19 '12 at 17:19

1 Answers1

0

If you mean concurrent inserts like described here: http://dev.mysql.com/doc/refman/5.0/en/concurrent-inserts.html then no, it doesn't make your inserts any faster. It simply means you can still read the table while the inserts take place.

This feature is only relevant for engines that use table-level locking.

sn00k4h
  • 443
  • 4
  • 10