From: Adam Powell
Date: March 22 1999 4:16pm
Subject: locking
List-Archive: http://lists.mysql.com/mysql/774
Message-Id: <002901be747f$5ec6ad60$0401a8c0@adam.shout-ads.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


Hi, thanks for all your help in getting this working... I have upgraded to
3.22.20 now, and its a lot better.  However we still have a LARGE problem.

We have an IP table that has SELECTs and INSERTs on the individual rows
about 80 inserts a second, and 1 insert every 3 seconds however sometimes
all the processes get locked because the selects are taking so long to go
through the table.  Does anybody have any ideas how we can configure it so
that the SELECTS and INSERTS can work together and not cause anything to
hang?  The table can be anything up to 2 million rows.... so it does take a
while to select.

Adam Powell
Click Agents Corp.,
Web : http://www.clickagents.com
Email : adam@stripped
Tel/Fax : +44 (0) 115 9532989