Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: kay.rozeb...@iowa.gov
-Original Message-
From: a.sm...@ukgrid.net [mailto:a.sm...@ukgrid.net]
Sent: Wednesday, August 03, 2011 3:25 PM
To: supr_star
Cc: mysql@lists.mysql.com
Subject: Re: very large import
On 8/3/2011 20:36, Nuno Tavares wrote:
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
...
The same conte
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-wikim
Quoting supr_star :
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
--
MySQL General Mailing List
For list archives
I recently recovered a very large corrupt database with your help. Now I'm
having a problem during the next step, importing all the data back into a clean
system. I have a 24GB dump file, the ibdata1 file was about 100GB when the
disk filled and everything got wrecked. I have a server with a
