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 process won't leave me alone

Discussion in 'General Discussion' started by RJ2, Jun 27, 2003.

  1. RJ2

    RJ2 Registered

    Joined:
    Jun 6, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    I have a MySQL process that runs non-stop. I can kill it using

    mysqladmin kill <id#>

    But it returns just moments later under a new ID.


    When I do " mysqladmin processlist " it shows the process as Sleeping :

    | 6056 | welsh_single | localhost | welsh_single | Sleep | 697

    The process eats up a lot of server resources and I have to keep killing it, but for the life of me I can't find out what script is causing this? The odd thing is the user's site is extremely low usage. He run a singles site with less than 20 users.

    I've rebooted, but it comes back.

    Where can I find the prob??
     
  2. RJ2

    RJ2 Registered

    Joined:
    Jun 6, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    More of the same. Any help on where I should look? Why would a MySQL process do this?

    +-------+-----------------+-----------+--------------+---------+-------+-------+--------
    ----------+
    | Id | User | Host | db | Command | Time | State | Info
    |
    +-------+-----------------+-----------+--------------+---------+-------+-------+--------
    ----------+
    | 9831 | welsh_single | localhost | welsh_single | Sleep | 12887 | |
    |
    | 10281 | welsh_single | localhost | welsh_single | Sleep | 14713 | |
    |
    | 10373 | welsh_single | localhost | welsh_single | Sleep | 7310 | |
    |
    | 11147 | welsh_single | localhost | welsh_single | Sleep | 12419 | |
    |
    | 12632 | welsh_single | localhost | welsh_single | Sleep | 7244 | |
    |
    | 12656 | welsh_single | localhost | welsh_single | Sleep | 7147 | |
    |
    | 13923 | welsh_single | localhost | welsh_single | Sleep | 3328 | |
    |
    | 14924 | root | localhost | | Query | 0 | | show pr
    ocesslist |
    +-------+-----------------+-----------+--------------+---------+-------+-------+--------
    ----------+

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page