My hosting provider is telling me that there are lot of sql processes running due to the SQL queries which are not getting killed automatically. SQL queries take more than the allowed execution time.
Due to this the my hosting account and all its domain gets down often.
Jan 31 15:30:34 md-40 mkill[27272]: killed: thread_id: 1201879 user: iyaffxpe_oxdemo host: localhost db: iyaffxpe_oxdemo cmd: Sleep time: 18
Feb 18 05:24:02 md-40 mkill[25482]: killed: thread_id: 16656380 user: iyaffxpe_oxtest host: localhost db: iyaffxpe_oxtest cmd: Sleep time: 17
This is getting really serious as all my actual live domains also get down often and should contact the support to kill the zombie process.