/usr/local/bin/mysql -h xxx -u xxx -Pxxx -pxxx -e 'show processlist'|grep -i "select" | awk '{if ($6 > 10) {printf "/usr/local/bin/mysql -h xxx -u xxx -Pxxx -pxxx -e \"kill %d\"\n",$1}}'|sh
为什么会提示线程id都不存在呢?ERROR 1094 (HY000) at line 1: Unknown thread id: 87807
ERROR 1094 (HY000) at line 1: Unknown thread id: 87808
ERROR 1094 (HY000) at line 1: Unknown thread id: 87811
ERROR 1094 (HY000) at line 1: Unknown thread id: 87812
ERROR 1094 (HY000) at line 1: Unknown thread id: 87813
ERROR 1094 (HY000) at line 1: Unknown thread id: 87814
ERROR 1094 (HY000) at line 1: Unknown thread id: 87817
ERROR 1094 (HY000) at line 1: Unknown thread id: 87818
ERROR 1094 (HY000) at line 1: Unknown thread id: 87819
ERROR 1094 (HY000) at line 1: Unknown thread id: 87824
ERROR 1094 (HY000) at line 1: Unknown thread id: 87826
ERROR 1094 (HY000) at line 1: Unknown thread id: 87827
ERROR 1094 (HY000) at line 1: Unknown thread id: 87830
ERROR 1094 (HY000) at line 1: Unknown thread id: 87834
ERROR 1094 (HY000) at line 1: Unknown thread id: 87835
ERROR 1094 (HY000) at line 1: Unknown thread id: 87841