Because ther eis a lot in there..and "time" is big number.
A:
from directly in the mysql interface? you can't. you'll have to write a script in another language or a stored procedure.
longneck
2009-12-14 22:14:18
+2
A:
You need to kill them one by one, MySQL does not have any massive kill command. You can script it in any language, for example in PHP you can use something like:
$result = mysql_query("SHOW FULL PROCESSLIST");
while ($row=mysql_fetch_array($result)) {
$process_id=$row["Id"];
if ($row["Time"] > 200 ) {
$sql="KILL $process_id";
mysql_query($sql);
}
}
Michal Čihař
2009-12-14 22:15:26
A:
Be careful you don't kill an optimize table query as you will hose that table.
philjohn
2009-12-14 22:16:05
What is an optimize table query?
TIMEX
2009-12-14 22:45:25
It's a query you run to perform some cleanup on a table, for instance fixing any split/deleted rows, sorting index pages, update statistics, compact the file after large deletes (especially where you have variable length columns such as VARCHAR).The long and short of it though, is do not kill any query that starts with OPTIMIZE TABLE unless you have a very recent backup!More details here: http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
philjohn
2009-12-15 09:44:15
A:
Check out the first comment on the mysql ref guide for the kill command. It provides a useful script.
Matt
2009-12-14 22:20:12