mysql 锁表解决

show open tables where in_use > 0;
SELECT trx_mysql_thread_id FROM information_schema.innodb_trx ORDER BY trx_started;
kill 89909;
show open tables where in_use > 0;