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.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 Quoting supr_star <suprstar1...@yahoo.com>: > 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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
