|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|
Bonjour, 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 ? Regards, Alex.
|• Mysqld crashes with my DELETE query.||BAUMEISTER Alexandre||3 Apr|
|• Re: Mysqld crashes with my DELETE query.||Mark Lo \(w\)||3 Apr|