LOAD DATA INFILE
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.
Subject
Written By
Posted
LOAD DATA INFILE
April 19, 2008 05:08PM
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.