ions?
Please see http://dev.mysql.com/doc/mysql/en/News-4.0.18.html :
INSERT DELAYED ... SELECT ... could cause table corruption because
tables were not locked properly. This is now fixed by ignoring DELAYED
in this context. (Bug #1983)
http://bugs.mysql.com/bug.php?id=1983
Obviously I
In the last episode (Nov 16), matt_lists said:
Please see http://dev.mysql.com/doc/mysql/en/News-4.0.18.html :
INSERT DELAYED ... SELECT ... could cause table corruption because
tables were not locked properly. This is now fixed by ignoring
DELAYED in this context. (Bug #1983)
Also consider buying MySQL support, which will give your requests a bit more
weight.
If that put select into table without locks back into mysql, I would
however, I dont think it will, I've got X dollars for hardware/software
on a given project, my only option is a different database for new
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
At 02:12 PM 11/15/2004, you wrote:
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
I think I found the problem
all our input files are prepped in a separate table
then insert delayed select * from temptable into production
4.0.18-19 removed this!
I dont know why they would allow insert delayed values, or load data
infile concurrent
but not on a select into table!?
Sucks,
In the last episode (Nov 15), matt_lists said:
I think I found the problem all our input files are prepped in a
separate table then insert delayed select * from temptable into
production
4.0.18-19 removed this!
I dont know why they would allow insert delayed values, or load data
infile
