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

  I may have copy all the lines from "mysqladmin process-list".

  While I'm doing my "DELETE FROM", another program is doing UPDATE on
  the query, but this should not be a problem.

 [12:32pm]# mysqladmin proc
+----+--------+-----------+-----------+---------+------+----------+------------------------------------------------------------------
------------------------------------+
| Id | User   | Host      | db        | Command | Time | State    | Info
                                    |
+----+--------+-----------+-----------+---------+------+----------+------------------------------------------------------------------
------------------------------------+
| 1  | dbuser | localhost | cotations | Query   | 48   | updating | UPDATE intraday_PAR
SET high=GREATEST(high,7.320000),low=LEAST(lo
w,7.320000),last=7.320000,volume=vo |
| 2  | dbuser | localhost | cotations | Sleep   | 0    |          |
                                    |
| 5  | root   | localhost | cotations | Query   | 255  | updating | delete from
intraday_PAR where date<'2001-04-03 00:00:00'
                                    |
| 50 | root   | localhost |           | Query   | 0    |          | show processlist
                                    |
+----+--------+-----------+-----------+---------+------+----------+------------------------------------------------------------------
------------------------------------+

  Regards,
  Alex.


Thread
[couldn't connect to the mysql server]ujwol3 Apr
  • Re: [couldn't connect to the mysql server]James Lyon3 Apr
  • Re: [couldn't connect to the mysql server]Ujwol3 Apr
    • Re[2]: [couldn't connect to the mysql server]role+mysql-readers3 Apr
    • Mysqld crashes with my DELETE query.BAUMEISTER Alexandre3 Apr
      • Re: Mysqld crashes with my DELETE query.Bob Hall3 Apr
    • Mysqld crashes with my DELETE query.BAUMEISTER Alexandre3 Apr
  • Re: Re[2]: [couldn't connect to the mysql server]Ujwol3 Apr
Re: Mysqld crashes with my DELETE query.Heikki Tuuri3 Apr