Hi,
I am new to MySQL and this listserv. I have a couple of questions about the
recommendations at the link given below.
1) If autocommit is turned off during the large load, could this cause the underlying
InnoDB log to grow too big?
2) If the unique checks and foreign key checks are turned off during the large load, are
the checks run for the newly loaded data when they are turned back on? If not, what kind
of errors would occur later if the loaded data contained duplicate keys or non-existent
foreign keys?
Kay Rozeboom
Information Technology Enterprise
Iowa Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@stripped
-----Original Message-----
From: a.smith@stripped [mailto:a.smith@stripped]
Sent: Wednesday, August 03, 2011 3:25 PM
To: supr_star
Cc: mysql@stripped
Subject: Re: very large import
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
