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
>
>
>
>