Solved

Mysql Process shows large number of locked processes

Posted on 2008-06-24
1
780 Views
Last Modified: 2008-06-26
Hi i'm running mysql on an apache server but recently i've begun to get a constant too many connections error when attempting to connect to the DB, i've also attempted to restart the sql server but the locked processes seem to keep returning, any idea what the cause of the problem is and how i can repair it ?
0
Comment
Question by:Senbonzakura
1 Comment
 
LVL 20

Accepted Solution

by:
virmaior earned 500 total points
ID: 21860780
are you using persistent connections?

this is a common issue when you do.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
mySql Syntax 7 54
How many transactions can mysql handle? 3 32
Determining creation & modification dates on MySQL tables 4 40
mysql date time 14 31
A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question