摘要: [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 醒嘞 阅读(321) 评论(0) 推荐(0) 编辑
摘要: 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 醒嘞 阅读(241) 评论(0) 推荐(0) 编辑