I'm using the MySQL connector for JDBC, processing a large CSV file using "LOAD DATA LOCAL INFILE" to insert records into a database running on another server within the local subnet.
After about a minute I get an error:
Communications link failure
Last packet sent to the server was 53123ms ago
I'm assuming there's some kind of timeout (understandable, some of the files I'm working with have over one million records). I'm not sure where the problem is, or how to fix it:
- JDBC connection pool settings?
- MYSQL on the target server has "wait_timeout" set to 28800 (documented as seconds, not ms)