mySQL CPU Use.

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Evan Barter

    mySQL CPU Use.

    I've noticed a server running with a higher load recently and I
    believe I've narrowed it down to mySQL. Taking a look at
    Cpu/Memory/Mysql Usage History in WebHost Manager I notice this:

    User Domain %CPU %MEM Mysql Processes
    mysql 100.98 161.94 0.0

    Top Process %CPU 24.3 /usr/sbin/mysqld --basedir/
    --datadir/var/lib/mysql --usermysql
    --pid-file/var/lib/mysql/s1.critticage.c om.pid --skip-locking

    Top Process %CPU 22.6 /usr/sbin/mysqld --basedir/
    --datadir/var/lib/mysql --usermysql
    --pid-file/var/lib/mysql/s1.critticage.c om.pid --skip-locking

    Top Process %CPU 19.8 /usr/sbin/mysqld --basedir/
    --datadir/var/lib/mysql --usermysql
    --pid-file/var/lib/mysql/s1.critticage.c om.pid --skip-locking

    Three identical processes. Is there any reason why there should be
    three running, each taking up a lot of CPU?

    I'm afraid I'm not much of a server admin, so any help would be
    appreciated (as long as it's "dumbed" down sufficiently ;-).
Working...