How do I avoid insert locks?
We updated from mysql 4.0.18 to 4.1.7
now all my inserts lock tables, I had 500 asp timeouts within 30 minutes after installing 4.1.7
I also had over 400 connections to the database, as all the threads were locked waiting, asp timeout is set to 30 seconds, the inserts always take up to an hour, but never caused locks before?!?
all our tables are myisam, and all data is adding, there are no deletes to these tables, they are log tables.
I'm going to try going back to 4.0.18
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
