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.

server hang due to mysql command

Discussion in 'Database Discussions' started by jitu_mania, Aug 23, 2012.

  1. jitu_mania

    jitu_mania Registered

    Joined:
    Aug 23, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ahmedabad, India
    cPanel Access Level:
    Root Administrator
    My server hangs everyday

    So i checked system health - process manager in whm

    there was a command given below

    /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/server.mydomain.com.err --pid-file=/var/lib/mysql/server.mydomain.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306

    see this image

    Capture.PNG

    here this mysql command process is taking 33% when there are only 5-6 online users.

    but sometimes it goes very high and server hangs.

    please tell me a solution .
     
  2. pwhjenny

    pwhjenny Well-Known Member

    Joined:
    Aug 31, 2012
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Run following command and check what queries running in the server.

     
Loading...

Share This Page