mysql_プロセスの終了
442 ワード
mysqlコマンド:
SHOW PROCESSLIST ; --
SELECT id,USER ,HOST,db,command,TIME,state,info FROM information_schema.processlist WHERE db='Sunivo_Settlement' AND state = 'Locked';
SELECT CONCAT ('kill ' ,id,';') kill_process FROM information_schema.processlist a WHERE db='Sunivo_Settlement';
KILL xxxx;