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
23775
May 24, 2005 05:52PM
13155
June 10, 2005 12:10PM
14491
June 10, 2005 05:36PM
11896
November 25, 2005 09:35AM
11509
December 15, 2005 05:16AM
10480
March 26, 2008 10:42AM
Re: very slow insert, very large iowait
9354
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.