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.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php