MySQL 终止睡眠进程 - Y.J.S

MySQL 终止睡眠进程

Jan 25, 2018

如何杀死 mysql 中的睡眠/空闲/僵尸进程。

Connect to `mysql` console and generate `rds_kill` command list with

SELECT GROUP_CONCAT('CALL mysql.rds_kill(', id SEPARATOR '); ') AS kill_list
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE command='Sleep';

Copy the output from above step and run them as commands

CALL mysql.rds_kill('12345'); CALL mysql.rds_kill('23456'); ...

mysql database

🇨🇳 🇯🇵 📍 ⌚