MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Partitions and LOAD DATA INFILE
5208
Daniel Stolzberg
May 07, 2009 09:54AM
Re: Partitions and LOAD DATA INFILE
2688
Rick James
May 08, 2009 08:50PM
Re: Partitions and LOAD DATA INFILE
2751
justin ux
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.