解决数据库事务锁导致crud超时
SELECT
trx_id,
trx_state,
trx_started,
trx_mysql_thread_id,
CURRENT_TIMESTAMP - trx_started AS RUN_TIME
FROM
information_schema.innodb_trx;
trx_id trx_state trx_started trx_mysql_thread_id RUN_TIME
2125227726 RUNNING 2022-04-01 15:49:08 108849 9027
kill 108849;
把 上一步查到的trx_mysql_thread_id 这个id杀掉(上一步中也可能查出有多条),就可以释放锁了。