3 messages in com.mysql.lists.mysqlspeed issue - inserts slowing down se...
FromSent OnAttachments
Daniel Cummings13 Oct 2004 12:01 
John McCaskey13 Oct 2004 12:15 
Dana Diederich13 Oct 2004 13:34 
Subject:speed issue - inserts slowing down selects
From:Daniel Cummings (Dani@BrickSoftware.com)
Date:10/13/2004 12:01:44 PM
List:com.mysql.lists.mysql

We have what is called a data grabber for quotes that is inserting rows into both InnoDb and MyIsam tables.

When the data is being imported ( inserted ), it is dramatically slowing clients down that are running queries against the table.

Our first attempt at a solution was to insert one row at a time. This doesn't seem to make a difference.

The next thing we tried is the "Insert Delayed" which as I stated in an earlier post, doesn't seem to work for InnoDb tables.

We are also looking at "Insert Low_Priority".

Does anyone have any suggestions?

TIA

Dan