The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

lot of mysql sleep threads.

Discussion in 'General Discussion' started by benito, Sep 4, 2007.

  1. benito

    benito Well-Known Member

    Joined:
    Jan 8, 2004
    Messages:
    296
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Mar del Plata - Argentina
    Since last weekends i see an excesive ammount of sleep threads on mysql. How can i limit the sleep threads ?
     
  2. benito

    benito Well-Known Member

    Joined:
    Jan 8, 2004
    Messages:
    296
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Mar del Plata - Argentina
    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.
     
  3. cPanelBilly

    cPanelBilly Guest

    Add the following under [mysqld] in your /etc/my.cnf
    Code:
    wait_timeout = 60
    
    Change the 60 as you see fit
     
Loading...

Share This Page