•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 456,537 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,159 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 5164 | Replies: 2
 |
•
•
Join Date: Oct 2007
Location: NewYork
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
kill sleep process/connections 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 want to kill all the sleep process in mysql , since it is unnecesserly taking the server memory and process..
Regards
Pooran Jaiswal
•
•
Join Date: Feb 2007
Location: india
Posts: 52
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
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.
•
•
•
•
Originally Posted by 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
i m oblised for all member of daniweb.as helping me every time.this is best site for those who want to learn themself.
•
•
Join Date: Nov 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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)
You have also two options:
1) In ssh, mysql | kill <procid>, or
2) In my.cnf, wait_timeout = 600 (time is in seconds)
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- ambiguous part 3 (C)
- "Server Busy"??? Spyware Related? (Viruses, Spyware and other Nasties)
- which process reads the cin (C++)
- How do I get rid of this icon on my desktop? (Windows NT / 2000 / XP / 2003)
- Links not working in web sites using Internet Explorer 6.0 (Viruses, Spyware and other Nasties)
- Closing external application (VB.NET)
- Need help with stubborn spyware problem (Viruses, Spyware and other Nasties)
- Quick Reference for Linux Commands (Getting Started and Choosing a Distro)
- Windows NT Display Properties (Windows NT / 2000 / XP / 2003)
- fwvjqcmdte.exe (Windows NT / 2000 / XP / 2003)
Other Threads in the MySQL Forum
- Previous Thread: Need a simple mysql search script
- Next Thread: MySql Replication problem
