Lock wait timeout exceeded; try restarting transaction MySQL 查询锁表信息,并生成 Kill id; 脚本
Lock wait timeout exceeded; try restarting transaction MySQL 查询锁表信息,并生成 Kill id; 脚本SELECT concat('KILL ',trx_mysql_thread_id,';') FROM information_schema.INNODB_TRX;