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;
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;