Pls help me to understand, is there any locking happens when we use LOAD DATA LOCAL INFILE F1 INTO TABLE T1.
If there is any locking? then what kind of locking it is table level or row level.
And what happens if we perform such operation in business hours, will it have any impact on APIs i.e. as APIs have select queries from the same table in which Loading is performed.
So APIs will respond normally or because of table locking (if there) ?
Will be great help guys, if you can respond on this asap.