监控持有sql和被堵塞的sql

Session 1:
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)

mysql> update ClientActionTrack20151125 set ip='8.8.8.8';


Session 2:
mysql> update ClientActionTrack20151125 set ip='9.9.9.9'
    -> ;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transactio

zabbix:/root/mysql# sh ./mon_mysql_all.sh 
,,,,,
112069896,555,update ClientActionTrack20151125 set ip='9.9.9.9',112069895,554,update ClientActionTrack20151125 set ip='8.8.8.8'
 mysql[192.168.11.187]   blocking_thread[554] blocking_query[update ClientActionTrack20151125 set ip='8.8.8.8']  blocking waiting_thread[555]'s update ClientActionTrack20151125 set ip='9.9.9.9'

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6198961.html