MYSQL如何查看进程和kill进程

SHOW PROCESSLIST;

KILL 41515;

KILL 42736;

#!/bin/bash
mysql -uroot -pMy_PassWord -e "show processlist" | grep -i "Query" > slow_query.log
for query in `cat slow_query.log | awk '{print $1}'`
do
   echo "kill $query;" > kill_slow_query.sql
done

mysql> source kill_slow_query.sql

#!/bin/bash
for query in `mysqladmin -uroot -pMy_Password processlist | grep -i 'Query' | awk '{print $2}'`
do
   mysqladmin kill ${query}
done

#!/bin/bash
mysql -uroot -pMy_Password -e "show processlist" | grep -i "Locked" > locked.log
for lock in `cat locked.log | awk '{print $1}'`
do
   echo "kill $lock;" > kill_locked.sql
done

mysql> source kill_locked.sql

#!/bin/bash
for lock in `mysqladmin -uroot -pMy_Password processlist | grep -i 'Locked' | awk '{print $2}'`
do
   mysqladmin kill ${lock}
done