Tag Info

New answers tagged


The mysql_load() function calls the open_and_lock_tables() function to lock the table mentioned in the LOAD DATA statement. MySQL obtains an exclusive lock on the table so that it can very quickly load data into the table. There is very little overhead in the LOAD DATA process, just the bare minimum parsing is done to make it work. The CONCURRENT option ...

Top 50 recent answers are included