My Oracle Support Banner

LOAD DATA LOCAL INFILE Hangs in Thread State System Lock (Doc ID 1617362.1)

Last updated on FEBRUARY 08, 2019

Applies to:

MySQL Server - Version 4.0 to 5.5 [Release 4.0 to 5.5]
Information in this document applies to any platform.

Symptoms

The LOAD DATA LOCAL INFILE command is very slow and have a "System Lock" thread state:

mysql> SHOW PROCESSLIST;

+--------+-------+-----------+------+---------+--------+-------------+------------------------------------------------+
| Id     | User  | Host      | db   | Command | Time   | State       | Info                                           |
+--------+-------+-----------+------+---------+--------+-------------+------------------------------------------------+
| 60310  | mysql | localhost | test | Query   | 869014 | System lock | LOAD DATA LOCAL INFILE '/tmp/data.txt' REPLACE |
+--------+-------+-----------+------+---------+--------+-------------+------------------------------------------------+

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 Workaround
 Permanent solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.