Linux batch kill mysql process, linux batch killmysql

Linux batch kill mysql process, linux batch killmysql

It is often the case that a process needs to be forcibly killed, but if the process starts many sub-processes, it must kill all the processes that come out of ps aux, if one kill is time-consuming and labor-consuming, an online mysql connection pool is full, resulting in batch kill processes. stop loss is very important, so efficiency must be improved, and awk must be used.
For example, batch kill mysql

Ps aux | grep mysql | awk '{print $2}' | xargs kill-9

Ps aux | grep mysql can detect all mysql processes. awk '{print $2}' prints the second column of all displays, that is, the pid. Xargs regards all the preceding parameters as the following input parameters in sequence.