MYSQL PROCESSESS LISTING AND KILL

MYSQL PROCESSES LISTING AND KILL

# mysql -uroot -p

mysql> show processlist\G
     Id: 1359
   User: root
   Host: localhost
     db: contentanalysis
Command: Query
   Time: 346
  State: Copying to tmp table
   Info: SELECT  SQL_CALC_FOUND_ROWS id, filepath FROM content WHERE filepath IN (  SELECT filepath
FROM cont

mysql> kill 1359;

mysql> show processlist;