List:General Discussion« Previous MessageNext Message »
From:Nuno Tavares Date:August 4 2011 12:36am
Subject:Re: very large import
View as plain text  
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
> 
> 
> 
> 

Thread
very large importsupr_star3 Aug
  • Re: very large importa.smith3 Aug
    • Re: very large importNuno Tavares4 Aug
      • Re: very large importMySQL)4 Aug
    • RE: very large importKay [DAS] Rozeboom4 Aug