2019独角兽企业重金招聘Python工程师标准>>>
show full processlist展示所有线程
show engine innodb status展示状态
如:
MySQL thread id 74048436, OS thread handle 0x7ff1f920a700, query id 965762090 10.37.18.76 daojia_root cleaning up
TABLE LOCK table `dbwww58com_dj_mobile`.`t_group_product` trx id 225762315 lock mode IX
RECORD LOCKS space id 904 page no 3 n bits 88 index `PRIMARY` of table `dbwww58com_dj_mobile`.`t_group_product` trx id 225762315 lock_mode X locks rec but not gap
TABLE LOCK table `dbwww58com_dj_mobile`.`t_group_spec_product` trx id 225762315 lock mode IX
RECORD LOCKS space id 901 page no 3 n bits 80 index `PRIMARY` of table `dbwww58com_dj_mobile`.`t_group_spec_product` trx id 225762315 lock_mode X locks rec but not gap
有线程id,query id ip等
INNODB_TRX是事务表,事务表里有事务开始时间,事务状态等,结合上面三个信息排查问题。