Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Hi Server Loads (mySql

Discussion in 'General Discussion' started by sbrad, Mar 8, 2002.

  1. sbrad

    sbrad Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    316
    I've been getting really high server loads with mySql, using 90+% of the CPU. How do I find out which user is doing this?
     
  2. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    316
    mysqladmin -p processlist

    (will show you current processes, and threads that are hanging in memory and more than likely abusing your sql server's resources)

    You'll need the mysql root pass here of course.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. sbrad

    sbrad Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    316
    Suweeeeeeeeeeeeet.

    Thanks
     
  4. DHL

    DHL Well-Known Member

    Joined:
    Mar 8, 2002
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    306
    How do you then kill that process? Just restart?

    Newbie :)

    Steve
     
  5. Daniel

    Daniel Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    165
    Likes Received:
    0
    Trophy Points:
    316
    Logged in as root you can also type mysql then at the mysql prompt type show processlist;

    You will get the same output but without having to put in the root pass each time. ;)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Juanra

    Juanra Well-Known Member

    Joined:
    Sep 22, 2001
    Messages:
    777
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Spain
    There's also an option in WHM, under the Mysql group, &Show MySQL processes&.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    316
    Location:
    Earth
    what about if both processlist via mysqladmin and by mysql says all connection in use , what to do? this happened to me several times.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice