Un lunedý mattina di concitazione; se rimangono tante query appese che possono condurre ad un deadlock meglio ucciderle.

Ecco come perpetrare il mass killing, in due passi.

 

Mass killing operation saves time. Do it in MySql itself:

Run these commands

mysql> select concat('KILL ',id,';') from information_schema.processlist
where info like '%___Pattern___%' and time > into outfile '/tmp/kkk.txt';

mysql> source /tmp/kkk.txt;

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>