Procedure that kill all the sleeping processes? (no replies)
(MySQL.com) Hi,
I'm using MySql 5.0.22 and I dont have the table processlist on information_schema.
So I dont know how exactly to implements the procedure with "show full processlist".
What I mean is - how can I insert it into a variable/cursor it..
The
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:10:37