PBRs blogspot: a lifetime of learning about GNU/linux.
Sharing lessons learned about GNU/linux, life, and the Internet.
Sunday, May 26, 2013
Kill all MySQL transactions
This is an emergency measure. I don't recommend you use it in production except when there's no other choice.
for i in `mysql -Ne "show processlist" | awk '{print $1}'`; do mysqladmin kill $i; done
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment