Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #This is a bullshit but... i will kill all the sleep connections which sleeping time starting with 8
- for a in `echo "show processlist" |mysql --user=root --password=tete coredb |egrep 'Sleep[[:space:]]+8[[:digit:]]+' |awk '{ print $1 }'`; do echo "KILL $a" | mysql --user=root --password=tete coredb; done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement