myapit

mysq-admin-tools

Nov 25th, 2020 (edited)
705
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. TOOLS
  2. ======
  3. mysqladmin --defaults-file=~/myown.cnf extended-status | grep -wi 'threads_connected\|threads_running' | awk '{ print $2,$4}'
  4. /usr/bin/mysql --defaults-file=/home/hafeez/myown.cnf --execute="select count(ID)  from information_schema.processlist " -sN
  5.  
  6. watch -n2 'mysql --defaults-file=/home/hafeez/myown.cnf --execute="select *  from information_schema.processlist ORDER BY INFO DESC "'
  7.  
Add Comment
Please, Sign In to add comment