From: Nuno Tavares
Date: August 4 2011 12:36am
Subject: Re: very large import
List-Archive: http://lists.mysql.com/mysql/225486
Message-Id: <4E39E983.3060506@dri.pt>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

The following page has some nice interesting stuff, assuming you have a
reasonable configuration in place (innodb_buffer_pool, etc[1])


http://download.oracle.com/docs/cd/E17952_01/refman-5.5-en/optimizing-innodb-bulk-data-loading.html


[1] http://gpshumano.blogs.dri.pt/2009/09/28/importing-wikimedia-dumps/
(second box)

-NT


Em 03-08-2011 21:24, a.smith@stripped escreveu:
> Quoting supr_star <suprstar1072@stripped>:
> 
>> Is there any way to speed up this process? by disabling indexes or
>> something?  I can't afford to be down for 3 more days...  
> 
> First stop, the mysql documentation:
> 
> http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html
> 
> 
> 
>