hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Why so many sleeping mysql processes?
Reply

Hosting Security and Technology Configuring and optimizing web hosting servers and operating systems, developing administration scripts, building servers, protecting against hackers, and general security (SSL certificates, etc.)
Forum Jump

Why so many sleeping mysql processes?

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 03-25-2007, 11:19 AM
Max Renn Max Renn is offline
Making it up as I go along
 
Join Date: Jun 2001
Posts: 726

Why so many sleeping mysql processes?


Hello,

I hope someone can help me with this.

When I run the command -

uptime; free -m; mysqladmin processlist

- I get a list of my mysql activity.

There are about 10 sleeping processes for mysql on one of my accounts.

Does anyone know why mysql processes might be sleeping like this?

For the record, there is a very quiet PHPBB forum running on the site in question.

Thank you.

Reply With Quote


Sponsored Links
  #2  
Old 03-25-2007, 01:26 PM
tanfwc tanfwc is offline
Web Hosting Master
 
Join Date: Apr 2004
Location: Singapore
Posts: 1,459
Maybe GoogleBot are on their board. If the process stay there for a long period of time, you should start worrying and check their account.

__________________
tanfwc

Reply With Quote
  #3  
Old 03-25-2007, 03:57 PM
logicsupport logicsupport is offline
Aspiring Evangelist
 
Join Date: May 2006
Location: World Wide Web
Posts: 380
Sleeping mysql processes are a way of keeping a database connection alive, which however can often cause performance degradation. If a large number of these processes don't eventually die, MySQL can run out of avaliable connections.

From the mysql processlist, find if there is a specific database and check if there is any problem on it. The particular database may be corrupt or you may even have to check your code to see if it is closing the mysql connections correctly.

Another thing you can do is to modify the 'wait_timeout' setting in your mysql configuration. In you my.cnf file, under [mysqld], edit or add the line as below:
wait_timeout=600

The above may not be a fix, but can be used to kill off sleeping mysql processes after an optimum time period.

__________________
LogicSupport.com - Support That Makes Sense!
Quality Server Management & Web Hosting Support



Last edited by logicsupport; 03-25-2007 at 04:02 PM.
Reply With Quote
Sponsored Links
Reply

Related posts from TheWhir.com
Title Type Date Posted
Beyond SOPA / PIPA at SXSW Blog 2012-03-16 15:34:26
Web Host Rackspace Launches Private Beta for MySQL Cloud Database Web Hosting News 2011-12-01 21:09:51
Parallels Now Offering Licenses for CloudLinux OS Web Hosting News 2011-10-26 17:29:25
CA Technologies Integrates CA Process Automation and VMware vCloud Director Web Hosting News 2011-10-20 19:09:10
Web Host FireHost Partners with Cloud Security Firm Gazzang for Data Encryption Web Hosting News 2011-08-16 20:33:43


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?