[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Mysql Process shows large number of locked processes

Posted on 2008-06-24
1
Medium Priority
?
792 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 2000 total points
ID: 21860780
are you using persistent connections?

this is a common issue when you do.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

608 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