Re: MYSQL Error 2013 load infile 15mln rec 6gb CSV
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 15 Oct 2014 10:25:50 +0000 (UTC)
Message-ID: <m1li3d$r09$1_at_solani.org>
Date: Wed, 15 Oct 2014 10:25:50 +0000 (UTC)
Message-ID: <m1li3d$r09$1_at_solani.org>
On Wed, 15 Oct 2014 01:53:21 +0000, vjp2.at 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 http://mgogala.byethost5.comReceived on Wed Oct 15 2014 - 12:25:50 CEST