Horje
kill all mysql processes Code Example
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;
Source: stackoverflow.com
bulk kill mysql processlist 
SELECT CONCAT('KILL ',id,';') AS IDs
FROM information_schema.processlist 
WHERE TIME >10
AND command = "sleep"
Source: stackoverflow.com
kill all mysql processes 
sudo killall mysqld



Shell

Related
linux find and delete files with name Code Example linux find and delete files with name Code Example
git bash set global username and password Code Example git bash set global username and password Code Example
list Code Example list Code Example
install heroku cli on linux Code Example install heroku cli on linux Code Example
git username and password in terminal Code Example git username and password in terminal Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 15



 

Horje