Has anybody seen something like this when using show processlist? Note how they have been killed, their status is null and the have been running for 171316 seconds. I killed them yesterday.
mysql> show processlist; +---------+-------------+-----------+-----------+---------+--------+-------+-------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-------------+-----------+-----------+---------+--------+-------+-------------------------------------------------+ | 1365767 | nativeadmin | localhost | webnative | Killed | 171316 | NULL | SELECT ModifyDate From file WHERE FileID=325322 | 1365770 | nativeadmin | localhost | webnative | Killed | 171316 | NULL | SELECT ModifyDate From file WHERE FileID=398169 | 1365773 | nativeadmin | localhost | webnative | Killed | 171316 | NULL | NULL | | 1395711 | nativeadmin | localhost | webnative | Sleep | 0 | | NULL | | 1397954 | root | localhost | NULL | Query | 0 | NULL | show processlist | +---------+-------------+-----------+-----------+---------+--------+-------+-------------------------------------------------+ 5 rows in set (0.00 sec) Any ideas on this? Thanks in advance, --Erik Zapien --------------------------------------------------------------------- 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