hi,

i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process..

Regards
Pooran Jaiswal

I don't know the that we can kill process in myaql or not,but it will be batter that u kill or sleep or close process(or connetion) by u r frunt hand aplication what ever u r using like java,c,c++,php etc.

hi,

i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process..

Regards
Pooran Jaiswal

The best approach is to add mysql_close() at the end of every page (as ajay_tabbu pointed out).

You have also two options:
1) In ssh, mysql | kill <procid>, or
2) In my.cnf, wait_timeout = 600 (time is in seconds)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.