Partitions and LOAD DATA INFILE
Hello,
I am inserting large numbers of rows (thousands to millions) at a time into a partitioned MyISAM database (by range, 10 partitions by modulus). The MySQL manual says that using LOAD DATA INFILE with partitioned databases has a 130kB buffer... is there anyway to increase the size of this buffer? I would assume that this would dramatically improve my LOAD DATA INFILE performance for large inserts. Is this correct?
Thanks for any advice!
-Dan
Subject
Views
Written By
Posted
Partitions and LOAD DATA INFILE
5146
May 07, 2009 09:54AM
2663
May 08, 2009 08:50PM
2705
May 11, 2009 03:49AM
Sorry, you can't reply to this topic. It has been closed.
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.