linux - How can I automatically kill sleeping processes in MySQL? -

i notice sleeping dead processes mysql remote logins using navicat. regularly hang db. have login , kill them manually always. there better automatic way monitor sleeping processes , kill them after while? thanks!

you can configure mysql wait_timeout , interactive_timeout automatically close such connections.