update语句卡住/ Fixing “Lock wait timeout exceeded; try restarting transaction” for a 'stuck" Mysql table?

1. 获取锁住的语句

select * from information_schema.innodb_trx

1. kill显示为lock的trx_mysql_thread_id

kill 55555

评论(0)