List:General Discussion« Previous MessageNext Message »
From:matt_lists Date:November 16 2004 1:26pm
Subject:Re: 4.1.7 insert locks killing me
View as plain text  
>>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 saw that, however here's my issue

insert delayed works on insert values

and on load data infile (concurrent)

but why not in insert from select

I view this as a showstopper on new projects, I dont want to dump my 
data to text and then load back into the database

Thread
4.1.7 insert locks killing mematt_lists15 Nov
  • 4.1.8gunmuse15 Nov
    • RE: 4.1.8Donny Simonton15 Nov
  • Re: 4.1.7 insert locks killing memos15 Nov
  • Re: 4.1.7 insert locks killing mematt_lists15 Nov
    • Re: 4.1.7 insert locks killing meDan Nelson15 Nov
      • Re: 4.1.7 insert locks killing mematt_lists16 Nov
        • Re: 4.1.7 insert locks killing meDan Nelson16 Nov
          • Re: 4.1.7 insert locks killing mematt_lists16 Nov