Long running MySQL processes - How can I automatically kill them.

jols

Well-Known Member
Mar 13, 2004
1,110
3
168
14763 mysql 15 0 86564 58M 824 S 2.4 5.8 174:28 1 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql

I am constantly discovering mysql processes that are up and running continuously for hours. I find that I can't just kill them with a simple:

kill 14763

I have to use this -9 option, ala:

kill -9 14763


Does anyone have a suggestion about how to automatically kill these mysql process that run on and on?

Thank you.