Re: very slow insert, very large iowait
I have the same problem. Insert into's are painfully slow. I do not have spatial indexes and have removed all indexes from tables. I am using INNODB and frequently get the dreaded too many locks error. If I import as a CSV using the mysqlimport the files take under 2 minutes. When I then insert from my staging tables to live it takes over 2 hours.
I can do the same insert into's in SQL Server in 4 minutes. But I am stuck with MySQL for this project.
Subject
Views
Written By
Posted
23937
May 24, 2005 05:52PM
13234
June 10, 2005 12:10PM
14589
June 10, 2005 05:36PM
11967
November 25, 2005 09:35AM
11572
December 15, 2005 05:16AM
10546
March 26, 2008 10:42AM
Re: very slow insert, very large iowait
9473
March 27, 2009 08:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.