/Shell/Bash/Kill all mysql processes

Kill all mysql processes

Kill mysql processlist in whose time more than 200

mysql> select group_concat(concat('KILL ',id,';')) from 
information_schema.processlist where user='root' and time > 500;

mysql> source /tmp/a.txt;

3

Source: stackoverflow.com

Bulk kill mysql processlist

SELECT CONCAT('KILL ',id,';') AS IDs
FROM information_schema.processlist 
WHERE TIME >10
AND command = "sleep"

1

Source: stackoverflow.com

Kill all mysql processes

sudo killall mysqld

0

Similar codes

4 votes243 views1 answer
Atualizar linux
Shell/Bash
5 votes224 views1 answer
How to activate administrator account in windows 10 command prompt
Shell/Bash
0 vote186 views1 answer
How to install newrelic agent on aws linux
Shell/Bash
0 vote200 views1 answer
Git check ssh local
Shell/Bash
0 vote247 views2 answers
Winrar script for appending date to archive
Shell/Bash
0 vote209 views1 answer
Spacemacs ubuntu
Shell/Bash
1 vote203 views1 answer
Ionic plugin list command
Shell/Bash
0 vote216 views1 answer
Install modules mu
Shell/Bash
1 vote263 views1 answer
How to install inkscape on Ubuntu
Shell/Bash
2 votes153 views1 answer
Vscode switch between terminals
Shell/Bash

Share