Need a cPanel expert to assist us with optimizing our cPanel/ Mysql service. Just this morning, the load average spiked to about 30, when it's normally under 5.
In the process manager, it shows that the mysql process is eating up about 500% CPU, and running mysqladmin status yields the below.
cPanel support says it has something to do with a a torrent of visitors to a site, but google analytics isn't showing anything weird for the related sites/users.
[root@server ~]# mysqladmin status
Uptime: 5718 Threads: 68 Questions: 9154351 Slow queries: 2115 Opens: 3984 Flush tables: 1 Open tables: 2000 Queries per second avg: 1600.970
Here's a screenshot of the Process Manager.
[url removed, login to view]
28 freelancers are bidding on average $106 for this job
Hi there, I can help you, please consider take a look at my profile. Relevant Skills and Experience linux Proposed Milestones $111 USD - fix Provide more details about your server, how much memory / cpu?
Mysql check and fix Relevant Skills and Experience Linux, System admin Proposed Milestones $60 USD - Mysql check and fix Do you have root access to your server?.
Hi, I will audit setting and will optimize server and database for improved performance . Thank you Relevant Skills and Experience I have more than 8 years experience. Proposed Milestones $88 USD - Optimisation.
Hello, Can you share more information about the issue so that I can check & proceed further? Thank you Relevant Skills and Experience Server Admin Proposed Milestones $77 USD - Project