Monitoring server load?

[pdstein]

We've been experiencing a high load on one of our servers lately and I'm trying to figure out the cause. Is there something built into WHM or a plugin that can be added that will log the CPU usage of various services (http, mysql, exim, etc) and then show the % of the load attributed to each?

In particular I'm interested in monitoring MySQL as one of the options we're considering is moving MySQL off of this server and putting it on its own server, but we want to be sure MySQL is a major culprit before doing that.

Thanks,
Paul

 

[cPanelDon]

We've been experiencing a high load on one of our servers lately and I'm trying to figure out the cause. Is there something built into WHM or a plugin that can be added that will log the CPU usage of various services (http, mysql, exim, etc) and then show the % of the load attributed to each?

In particular I'm interested in monitoring MySQL as one of the options we're considering is moving MySQL off of this server and putting it on its own server, but we want to be sure MySQL is a major culprit before doing that.

Thanks,
Paul

I recommend reviewing the following resources for possible ideas and methods to help investigate the specific system resource usage:

• How to find MySQL abusers? - cPanel Forums
• cPanel Forums - View Single Post - How to determine which websites are the busiest?
• cPanel Forums - View Single Post - Getting the data of Daily Process Log

 

[pdstein]

Thanks for your help.

If I look in the "Daily Process Log" and the CPU % for user mysql, is that an accurate value for the % of CPU used by MySQL? I'm suspicious because one user is shown as using 296% The server does have 4 processors, so perhaps it's accurate if we divide the number by 4?

Thanks,
Paul