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

J

jols

Well-Known Member
Mar 13, 2004
1,107
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.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
charliecres too long enumeration/set value for column access Databases 1
D SOLVED cpanel MariaDB will no longer be supported? Databases 3
S MySQL queries are taking very long time to execute Databases 3
M SOLVED Long-running MySQL queries Databases 3
F httpd and mysql long running process Databases 1
Similar threads
too long enumeration/set value for column access
SOLVED cpanel MariaDB will no longer be supported?
MySQL queries are taking very long time to execute
SOLVED Long-running MySQL queries
httpd and mysql long running process
Top Bottom