Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    RJ2
    RJ2 is offline
    Registered User
    Join Date
    Jun 2003
    Posts
    4

    Default MySQL process won't leave me alone

    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. #2
    RJ2
    RJ2 is offline
    Registered User
    Join Date
    Jun 2003
    Posts
    4

    Default

    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:

Similar Threads & Tags
Similar threads

  1. MySQL Won't (Re)start
    By Alcan in forum Database Discussions
    Replies: 1
    Last Post: 07-19-2011, 05:05 PM
  2. MySQL 5.0.85 won't install
    By Reado in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 11-30-2009, 03:42 PM
  3. Http process won't die off and eating up cpu & ram.
    By gundamz in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 03-02-2008, 10:32 PM
  4. Mysql with process nobody.
    By WhiteBear in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 02-19-2004, 12:57 PM
  5. MySQL process
    By vizaweb in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 01-13-2004, 06:22 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube