server hang due to mysql command

Discussion in 'Databases' started by jitu_mania, Aug 23, 2012.

  1. #1
    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.jpg

    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 .
     
    jitu_mania, Aug 23, 2012 IP
  2. WeddiGo

    WeddiGo Greenhorn

    Messages:
    40
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    18
    #2
    what's your query?
     
    WeddiGo, Sep 22, 2012 IP