使用shell脚本杀mysql会话

#!/bin/bash

# 参数检查
if [ $# -ne 5 ]; then
    echo "Usage: $0 <IP> <Port> <User> <Password> <Concurrency>"
    exit 1
fi

IP=$1
PORT=$2
USER=$3
PASSWORD=$4
CONCURRENCY=$5


$(mysql -h${IP} -P${PORT} -u${USER} -p${PASSWORD} -e "use sysdb;CREATE TABLE processlist_copy LIKE information_schema.processlist;")
$(mysql -h${IP} -P${PORT} -u${USER} -p${PASSWORD} -e " INSERT INTO sysdb.processlist_copy SELECT * from information_schema.processlist;")

# 获取活跃线程ID
THREAD_IDS=$(mysql -h${IP} -P${PORT} -u${USER} -p${PASSWORD} -e "select * from information_schema.processlist where user like 'dbproxy%'  " | awk 'NR>2{print line}{line=$0} END{print line}' | awk '{print $1}')



# 并发kill活跃线程

for THREAD_ID in ${THREAD_IDS}; do
	echo ${THREAD_ID}
        mysql -h${IP} -P${PORT} -u${USER} -p${PASSWORD} -e "KILL ${THREAD_ID};"  & 
done


wait

echo "All active threads have been killed."