Skip navigation links

MySQL Forums :: GIS :: very slow insert, very large iowait


Advanced Search

Re: very slow insert, very large iowait
Posted by: Tom Nordgren ()
Date: March 27, 2009 08:22AM

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.

Options: ReplyQuote


Subject Views Written By Posted
very slow insert, very large iowait 21169 05/24/2005 05:52PM
Re: very slow insert, very large iowait 12138 Dov Hit 06/10/2005 12:10PM
Re: very slow insert, very large iowait 13272 06/10/2005 05:36PM
Re: very slow insert, very large iowait 10930 siyong li 11/25/2005 09:35AM
Re: very slow insert, very large iowait 10596 Arnaud Lesauvage 12/15/2005 05:16AM
Re: very slow insert, very large iowait 9652 Peter Nachname 03/26/2008 10:42AM
Re: very slow insert, very large iowait 7805 Tom Nordgren 03/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.