Member Avatar for pooranjaiswal

hi,

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

Regards
Pooran Jaiswal

  • 3 Contributors
  • 2 Replies
  • 138 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by CesarF
Member Avatar for ajay_tabbu

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

Member Avatar for CesarF

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.