some mysql watch commands

mysql_debug

-- Mysql processlist
watch -n 0.1 'mysql -uroot -proot kinton -e "select * from information_schema.PROCESSLIST"'

-- Mysql contention
watch -n 0.1 "mysql -uroot -proot kinton -e \"select * from information_schema.PROCESSLIST where state = 'User lock'\""

-- gdb Mysql (full credits to http://poormansprofiler.org)
#!/bin/bash
nsamples=1
sleeptime=0
pid=$(pidof mysqld)

for x in $(seq 1 $nsamples)
  do
    gdb -ex "set pagination 0" -ex "thread apply all bt" -batch -p $pid
    sleep $sleeptime
  done | \
awk '
  BEGIN { s = ""; } 
  /Thread/ { print s; s = ""; } 
  /^\#/ { if (s != "" ) { s = s "," $4} else { s = $4 } } 
  END { print s }' | \
sort | uniq -c | sort -r -n -k 1,1