kill mysql show processlist kill

By fushanlang, on October 26th, 2013

#!/bin/bash
date

for id in `mysqladmin   processlist | grep -i  "your detect filter" |awk '{print $2}'`
do
mysqladmin kill ${id};
echo  ${id}.'\n';
done

Leave a Reply