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.

MySQL Sleep Problem!!!

Discussion in 'General Discussion' started by Mysteerie, Nov 30, 2004.

  1. Mysteerie

    Mysteerie Well-Known Member

    Joined:
    Dec 29, 2003
    Messages:
    129
    Likes Received:
    0
    Trophy Points:
    16
    On a few of my users sites message boards are creating Sleep Command in my MySQL Process list multiple times, making thier message boards extremely slow and keeps logging out thier users.

    I have actually searched and they said to try to turn persistent connections off, I did this and restarted the server. The problem is still happening.

    Does anyoen have any other solution, I really need help with this one.
     
  2. EdRooney

    EdRooney BANNED

    Joined:
    Oct 21, 2004
    Messages:
    166
    Likes Received:
    0
    Trophy Points:
    0
    Sleep commands will not make the server slow.
     
  3. Mysteerie

    Mysteerie Well-Known Member

    Joined:
    Dec 29, 2003
    Messages:
    129
    Likes Received:
    0
    Trophy Points:
    16
    It's not making teh site slow, the boards on teh site however is slow (the issusing db), but other site's db are fine. Just happens to the users's db who's mysql process list are repeating the command "Sleep" multiple times.

    For example:

    +------+-----------+-----------+-----------------+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +------+-----------+-----------+-----------------+---------+------+-------+------------------+
    | 345 | eximstats | localhost | eximstats | Sleep | 1042 | | |
    | 9482 | gamefaq2 | localhost | gamefaq2_boards | Sleep | 1 | | |
    | 9483 | gamefaq2 | localhost | gamefaq2_boards | Sleep | 9 | | |
    | 9489 | gamefaq2 | localhost | gamefaq2_boards | Sleep | 15 | | |
    | 9497 | gamefaq2 | localhost | gamefaq2_boards | Sleep | 3 | | |
    | 9503 | gamefaq2 | localhost | gamefaq2_boards | Sleep | 25 | | |
    | 9506 | gamefaqs | localhost | gamefaqs_SQL | Sleep | 13 | | |
    | 9513 | root | localhost | | Query | 0 | | show processlist |
    +------+-----------+-----------+-----------------+---------+------+-------+------------------+

    (And when it takes 45 seconds for the boards to load any page, I consider that slow, so obviosly there is a problem. Now I'm trying to find out where. It's not only happening to me, but to everyone on those boards).
     
    #3 Mysteerie, Nov 30, 2004
    Last edited: Nov 30, 2004
  4. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    iam not good in coding with php/mysql.. but what does the "sleep" command do ? something like the "sleep" in C ?
     
  5. Mysteerie

    Mysteerie Well-Known Member

    Joined:
    Dec 29, 2003
    Messages:
    129
    Likes Received:
    0
    Trophy Points:
    16
    Well I dont' think it's really the command itself causing the problem. I bilieve it's more of bieng initated and taking a long time to terminate (it does eventally going away). Though te command itself just keeps coming and fluctuates.
     
Loading...

Share This Page