Guest User

Untitled

a guest
Dec 7th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. The following command intends to kill queries which have execute time greater than 30s and save terminated queries to database.
  2.  
  3. ```
  4. pt-kill --host=localhost --user=root --password=root \
  5. --busy-time=30 --interval=5s \
  6. --log-dsn=h=localhost,D=pt_kill,t=kill_log,P=3306,u=root,p=root \
  7. --kill --daemonize --ignore-user=backup
  8. ```
Add Comment
Please, Sign In to add comment