Re: MYSQL Error 2013 load infile 15mln rec 6gb CSV

From: Mladen Gogala <>
Date: Wed, 15 Oct 2014 10:25:50 +0000 (UTC)
Message-ID: <m1li3d$r09$>

On Wed, 15 Oct 2014 01:53:21 +0000, wrote:

> Any clues? I set connect_timeout to 7000 and select_limit to 100mln and
> it still dies at 600 sec

Your problem can be solved by switching to Oracle 12c EE, with multitenant,  advanced compression, diagnostic+tuning pack and partitioning options, preferably on T5-2, just like the one Jonathan Lewis described in his recent blog post.

Mladen Gogala
The Oracle Whisperer
Received on Wed Oct 15 2014 - 12:25:50 CEST

Original text of this message