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.

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:
    16
    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:
    16
    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.
     
  3. sbrad

    sbrad Well-Known Member

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

    Thanks
     
  4. DHL

    DHL Well-Known Member

    Joined:
    Mar 8, 2002
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    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:
    16
    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. ;)
     
  6. Juanra

    Juanra Well-Known Member

    Joined:
    Sep 22, 2001
    Messages:
    777
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Spain
    There's also an option in WHM, under the Mysql group, &Show MySQL processes&.
     
  7. big

    big Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    224
    Likes Received:
    0
    Trophy Points:
    16
    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