/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 vote222 views1 answer
Dockerd failed to start daemon: failed to get temp dir to generate runtime scripts
Shell/Bash
0 vote198 views1 answer
How do I do 'dir /s /b' in PowerShell?
Shell/Bash
0 vote185 views1 answer
Github pulic keys
Shell/Bash
0 vote198 views1 answer
Uxmovemen
Shell/Bash
0 vote201 views1 answer
Git pelak
Shell/Bash
10 votes215 views5 answers
Node version manager
Shell/Bash
0 vote211 views1 answer
Sudo: /etc/sudoers is owned by uid 1001, should be 0 sudo: no valid sudoers sources found, quitting
Shell/Bash
10 votes191 views2 answers
Ng cli generate component
Shell/Bash
0 vote214 views1 answer
Installer-snap change in progress
Shell/Bash
7 votes215 views2 answers
Bash remove extension
Shell/Bash

Share