/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

0 vote233 views1 answer
Install pug
Shell/Bash
21 votes284 views1 answer
Brew m1
Shell/Bash
2 votes255 views1 answer
Get current timestamp shell
Shell/Bash
0 vote258 views1 answer
Node user installed packages
Shell/Bash
13 votes246 views2 answers
How to delet file comand promt linux
Shell/Bash
0 vote243 views1 answer
Destroy linux with one command
Shell/Bash
0 vote224 views1 answer
Mvn clean install skip checkstyle
Shell/Bash
0 vote234 views1 answer
Install onedrive in ubuntu 18.04
Shell/Bash
1 vote248 views1 answer
Not digitally signed. you cannot run this script on the current system
Shell/Bash
0 vote270 views1 answer
Sudo msys2
Shell/Bash

Share