hi,
i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process..
Regards
Pooran Jaiswal
hi,
i want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process..
Regards
Pooran Jaiswal
Jump to PostI 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 …
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)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.