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;