MySQL Forums
Forum List  »  Partitioning

Partitions and LOAD DATA INFILE
Posted by: Daniel Stolzberg
Date: May 07, 2009 09:54AM


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!


Options: ReplyQuote

Written By
Partitions and LOAD DATA INFILE
May 07, 2009 09:54AM

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.