How to fast kill all query MySQL (for case stuck process caused full session query)

Commandline server linux (centos, redhat, ubuntu, freebsd)

mysql -e "show full processlist;" -ss | awk '{print "KILL "$1";"}'| mysql

note : this action can impact to session replication, suggest to manual query exec "start slave" again.





Posting Komentar

Lebih baru Lebih lama