MySQL Forums
Forum List  »  Maria

LOAD DATA INFILE
Posted by: Mark Callaghan
Date: April 19, 2008 05:08PM

How will Maria handle LOAD DATA INFILE when there are many rows in the file? LOAD DATA INFILE uses one transaction and the Maria buffer cache might be too small to buffer all rows prior to commit. This is a problem for InnoDB in that extra IO is done by fuzzy checkpointing and a partial solution in InnoDB is to make the transaction log file as large as possible.

Options: ReplyQuote


Subject
Written By
Posted
LOAD DATA INFILE
April 19, 2008 05:08PM
April 28, 2008 05:28AM


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.