title: what lock will mysql issue for 'load data infile' on innodb?
body: <p>I'm using <code>LOAD DATA INFILE</code> on an InnoDB table, and I see "System lock" status in <code>SHOW PROCESSLIST</code>. What lock exactly does InnoDB lock in this situation? How can I check what is locked?</p>