如果你的生产环境够多,业务够复杂,你就懂了pt-kill:
pt-kill –host=ip –port=port –user=username –password=password –match-info "select|SELECT" –busy-time 1800 –victims all –interval 60 –daemonize –kill –print –log=/tmp/kill_detail.log
如果是rds,需要加上–no-version-check参数:
pt-kill –host=ip –port=port –user=username –password=password –match-info "select|SELECT" –busy-time 1800 –victims all –interval 60 –daemonize –kill –print –no-version-check –log=/tmp/kill_detail.log