MySQL Forums
Forum List  »  Falcon

Re: Falcon and LOAD DATA INFILE
Posted by: Hakan Kuecuekyilmaz
Date: April 19, 2008 05:16PM

Mark,

we do the same as InnoDB and commit internally every 10k queries in case of LOAD DATA.

storage/falcon/ha_falcon.cpp

if ((++insertCount % LOAD_AUTOCOMMIT_RECORDS) == 0)
	switch (thd_sql_command(mySqlThread))
		{
		case SQLCOM_LOAD:
		case SQLCOM_ALTER_TABLE:
		case SQLCOM_CREATE_TABLE:
		case SQLCOM_CREATE_INDEX:
			storageHandler->commit(mySqlThread);

Hakan Küçükyılmaz, MariaDB http://askmonty.org/



Edited 1 time(s). Last edit at 04/19/2008 05:52PM by Hakan Kuecuekyilmaz.

Options: ReplyQuote


Subject
Written By
Posted
Re: Falcon and LOAD DATA INFILE
April 19, 2008 05:16PM


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.