#1 (permalink)  
Old 09-04-2007, 10:43 AM
Registered User
 
Join Date: Jan 2004
Location: Mar del Plata - Argentina
Posts: 220
benito
lot of mysql sleep threads.

Since last weekends i see an excesive ammount of sleep threads on mysql. How can i limit the sleep threads ?
__________________
Cristian
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 09-04-2007, 11:15 AM
Registered User
 
Join Date: Jan 2004
Location: Mar del Plata - Argentina
Posts: 220
benito
I looked into that variable, i got 300 there. But the strange thing is that mytop shows me queries with more than 300 secs.

Now i will see how it works with 60.
__________________
Cristian
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 09-04-2007, 11:15 AM
cPanelBilly
Guest
 
Posts: n/a
Add the following under [mysqld] in your /etc/my.cnf
Code:
wait_timeout = 60
Change the 60 as you see fit
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 07:24 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
© cPanel Inc