-1

I'd like to preface this by saying im a total newbie when it comes to server administration. With that out of the way.....

I'm scratching my head wondering why my WHM daily process log is showing such a high % of max cpu usage (160%, which i assume means 1.6 cores fully utilized)

/usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql --plugin-dir/usr/lib64/mysql/plugin --usermysql --log-error/var/lib/mysql/xxx.yyyyyyy.com.err --open-files-limit5000000 --pid-file/var/lib/mysql/xxx.yyyyyyy.com.pid

I'm not sure what this means... Is there some kind of error with my settings? What should i tweak?

Also, mailnull is using up quite a bit of CPU as well.

What should my next moves be?

drew
  • 1
  • 2
    kind of impossible to answer –  May 22 '15 at 06:00
  • you need to analyse things like the slow query log, and monitor general process activity to see what it is exactly that's eating the cpu. not really a question for stackoverflow tho – pala_ May 22 '15 at 06:03
  • serverfault stack exchange ( http://serverfault.com/ ) *might* be a more useful place to ask, but only once you've got a more specific question to ask them. – Martin Mar 19 '16 at 10:41

1 Answers1

1

Run SHOW PROCESSLIST to see queries being processed and their run time. Enable slow query log to catch slow queries. Use mysqltuner.pl to see tuning suggestions.

umka
  • 1,655
  • 1
  • 12
  • 18