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.

MySQL load in whm

Discussion in 'General Discussion' started by mhkstr, Sep 17, 2008.

  1. mhkstr

    mhkstr Member

    Joined:
    Feb 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    hello friends,
    i found from last week under the page CPU/Memory/MySQL Usage it is showing

    mysql 11.85 2.07 0.0
    Top Process %CPU 13.4 /usr/sbin/mysqld-max --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/servername.com.pid --skip-external-locking
    Top Process %CPU 12.9 /usr/sbin/mysqld-max --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/servername.com.pid --skip-external-locking
    Top Process %CPU 12.8 /usr/sbin/mysqld-max --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/servername.com.pid --skip-external-locking

    this text is marked yellow. how can i fix the load of mysql?
    how can i find out that who is putting the load?

    my
    MySQL version 4.1.22-standard
    PHP version 5.2.6
    Operating system Linux
    Kernel version 2.6.18-53.1.13.el5
    cPanel Version 11.23.6-RELEASE
    cPanel Build 27225
     
  2. Kailash1

    Kailash1 Well-Known Member

    Joined:
    Nov 27, 2006
    Messages:
    252
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    You will get the detailed information of current running MySQL processes using below command:

    watch -n 0.5 mysqladmin proc

    You will need to login as root user via SSH.

    Kailash
     
  3. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Installing and using mytop would also help as well as enabling slow query logging and ensuring that you've at least done some MySQL tuning (e.g. query caching).
     
  4. Zwer

    Zwer Registered

    Joined:
    May 25, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Optimising SQL Queryes !!!
     
Loading...

Share This Page