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 freelance font une offre moyenne de $106 pour ce travail
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?.
I am a skilled server admin, i can find out what is causing the high cpu issue for you. let discuss more via private message, thanks. Relevant Skills and Experience I am a skilled server admin, i can find out what is Plus
What it looks like is mysql isn't using any memory, so there's no caching going on and it runs like a dog. I can optimize it for you and ensure it runs well, according to your hardware. Relevant Skills and Experience Plus
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
Expert in server management SSL Certificate, Cpanel/WHM, Dns,Centos, web panel, Apache, Plesk Panel IIS,Debian, Nginx, Ubuntu power MTA, enterspire,Aws,Expert in Migration services Relevant Skills and Experience 6+ Plus
Hi I have 3 years of experience as Linux admin . I can Optimize your CPanel/MySQL . Moreover I can start your work right away Thanks
Hi, I'm a Linux sysadmin with 15 years of experience. According to the symptoms, this is probably related with slow queries. Would love to help you solve it. Relevant Skills and Experience Linux, MySQL Proposed Mil Plus
HI, We will audit complete server and optimize cpanel for the traffic. Thank you. Relevant Skills and Experience More than 5 years in this field Proposed Milestones $55 USD - We will audit complete server and optim Plus
Hello I can tune your server (mysql exactly) for better performance Also i can see other issues, which can slow your server Regards Relevant Skills and Experience linux / php / mysql / tuning / optimization Proposed Plus
Hello I am expert in mysql so I can fix this problem. may be you there is a bug in your scripts so it is making too many connections. feel free to contact me. thanks Relevant Skills and Experience mysql Propose Plus
Dear Client, We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, PSD to HTML, Angular JS, Node JS photoshop, OPencart, Codeignitor, Laravel and many other technologies. Please have a look a Plus