MySQL Processes Locking Up

Print Thread

Hop To

MySQL Processes Locking Up #38925 01/08/2004 1:34 PM
Joined: Jun 2006 Posts: 73 C cdavis journeyman
cdavis journeyman C Joined: Jun 2006 Posts: 73	I've had trouble with MySQL dying in the wee hours of the morning. Today, it was 5:41am. When I checked the processes, there were 56 locked processes tied to my problem Threads database. I have repaired and optimized this database in the last week or two, but the problem persists. I have another instance of Threads on this server, but it's less-active database did NOT show any locked processes. I've been told that MySQL can become zombie if there are a lot of locked processes - that sounds like my problem.

Entire Thread
Subject	Posted By	Posted
MySQL Processes Locking Up	cdavis	01/08/2004 5:34 PM
Re: MySQL Processes Locking Up	J.C.	01/08/2004 10:30 PM
Re: MySQL Processes Locking Up	cdavis	01/09/2004 2:58 PM
Re: MySQL Processes Locking Up	cdavis	01/10/2004 6:54 PM
Re: MySQL Processes Locking Up	J.C.	01/10/2004 11:22 PM
Re: MySQL Processes Locking Up	cdavis	01/11/2004 2:30 AM
Re: MySQL Processes Locking Up	J.C.	01/11/2004 3:23 AM
Re: MySQL Processes Locking Up	cdavis	01/12/2004 5:19 PM
Re: MySQL Processes Locking Up	Rick	01/12/2004 6:32 PM
Re: MySQL Processes Locking Up	cdavis	01/14/2004 2:17 PM
Re: MySQL Processes Locking Up	David Dreezer	01/14/2004 11:09 PM
Re: MySQL Processes Locking Up	cdavis	01/15/2004 1:24 PM
Re: MySQL Processes Locking Up	David Dreezer	01/15/2004 11:01 PM
Re: MySQL Processes Locking Up	johngibbons	03/01/2004 7:03 PM
Re: MySQL Processes Locking Up	Rick	03/01/2004 11:43 PM
Re: MySQL Processes Locking Up	johngibbons	03/02/2004 12:37 AM
Re: MySQL Processes Locking Up	johngibbons	03/02/2004 10:00 PM
Re: MySQL Processes Locking Up	Rick	03/03/2004 12:40 AM
Re: MySQL Processes Locking Up	johngibbons	03/04/2004 6:22 PM
Re: MySQL Processes Locking Up	JoshPet	03/05/2004 1:40 AM
Re: MySQL Processes Locking Up	johngibbons	03/08/2004 8:20 PM
Re: MySQL Processes Locking Up	JoshPet	03/09/2004 4:57 AM

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support MySQL Processes Locking Up