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

🇨🇳 🇯🇵 📍 ⌚