List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:April 3 2001 10:49am
Subject:Mysqld crashes with my DELETE query.
View as plain text  

  I  have  re-run  my query without the other program trying to UPDATE
  the table :

mysql> delete from intraday_PAR where date<'2001-04-03 00:00:00';
Query OK, 364842 rows affected (32.95 sec)

  It works.

  Why did both threads lock each other.

  There  is one doing a lot of UPDATE and my from the console doing my
  DELETE. The DELETE should lock the table (so lock UPDATE) delete the
  rows and then unlock the table isn't it ?


Mysqld crashes with my DELETE query.BAUMEISTER Alexandre3 Apr
Re: Mysqld crashes with my DELETE query.Mark Lo \(w\)3 Apr