High CPU Usage on MySQL Service
Hi Team,
We are noticing consistently high CPU usage (around 180%+) on the MySQL process (/usr/sbin/mysqld) from our WHM panel. This is impacting overall server performance.
Could you please investigate and help us optimize or suggest the required server/database tuning to handle this load?
Thanks,
-
Hey there! We wouldn't be able to recommend anything specific without taking a look at the server, as this could just be normal usage for the amount of traffic your database is receiving.
The first thing I like to check with high MySQL usage is this command:
mysqladmin proc status
as that will show what queries are happening on the server in real time. If you see anything out of the ordinary there, or if there are a large number of requests for a specific site, or if you see a large number of hung queries, that could indicate an issue with a particular database.
Recently we have added a tool inside WHM >> Edit Database Configuration that will make recommendations for your specific server based on what it sees, so you could also review that for more specific details about your system.
0
Please sign in to leave a comment.
Comments
1 comment