2018年4月26日
Query Rewrite Plugins
摘要： [root@ZST1 ~] mysql --login-path=3306 </usr/local/mysql/share/install_rewriter.sql mydba@192.168.85.132,3306 [(none)]> create database qrp_drop; Query 阅读全文
posted @ 2018-04-26 14:01 醒嘞 阅读(330) 评论(0) 推荐(0)
Identifying a Blocking Query After the Issuing Session Becomes Idle
摘要： Identifying a Blocking Query After the Issuing Session Becomes Idle #查看阻塞信息 select * from sys.innodb_lock_waits\G #根据blocking_pid得到源头会话的最后一个SQL select 阅读全文
posted @ 2018-04-26 11:55 醒嘞 阅读(254) 评论(0) 推荐(0)