Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL processes

Status
Not open for further replies.
venketb

venketb

MIS
Joined
May 31, 2003
Messages
6
Location
IN
Hi,

Is there a way to detect stripped connections & the related processes and to kill/close them. When the client shuts abnormally, the process dangles for quite long on the MySQL server.

Thank you.

 
Sort by date Sort by votes
maybe
mysqladmin -u root -ppassword processlist
and pipe it through awk/grep and pipe it to kill command ?


gry online
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question Question
MySQL calculator tools
Replies
0
Views
671
EdZzy
E
lupidol
  • Locked
  • Question Question
Cannot create new table in mySQL
Replies
6
Views
1K
lupidol
lupidol
lupidol
  • Locked
  • Question Question
mysql cannot add rows with "UNION"
Replies
5
Views
993
Chris Miller
Chris Miller
dylim
  • Locked
  • Question Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
837
spamjim
spamjim
dylim
  • Locked
  • Question Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
1K
dylim
dylim

Part and Inventory Search

Sponsor

Back
Top