cPanel / MySQL Assistance

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]

Taidot: Linux, MySQL, SQL, Järjestelmänvalvoja

Näytä lisää: grant all privileges mysql cpanel, cpanel documentation remote mysql, how to create database in cpanel phpmyadmin, how to connect database in cpanel, mysql database wizard download, mysql cpanel download, cpanel mysql user privileges, how to import mysql database in cpanel, lighttpd php mysql cpanel, migrate standalone mysql cpanel, copy mysql cpanel, transfer mysql cpanel domain, reinstall mysql cpanel, perl mysql cpanel, mysql customer assistance sow

Tietoa työnantajasta:
( 0 arvostelua ) Fort Worth, United States

Projektin tunnus: #14811463

28 freelanceria on tarjonnut keskimäärin 106 $ tähän työhön


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?

111 $ USD 1 päivässä
(105 arvostelua)

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?.

60 $ USD 1 päivässä
(170 arvostelua)

A proposal has not yet been provided

72 $ USD 3 päivässä
(235 arvostelua)

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 Lisää

244 $ USD 4 päivässä
(141 arvostelua)

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 Lisää

60 $ USD 1 päivässä
(117 arvostelua)
50 $ USD 3 päivässä
(150 arvostelua)

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.

88 $ USD 1 päivässä
(80 arvostelua)

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

77 $ USD 3 päivässä
(82 arvostelua)

I am mysql dba having more then 10 yrs of experience

110 $ USD 2 päivässä
(43 arvostelua)

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+ Lisää

72 $ USD 0 päivässä
(34 arvostelua)
155 $ USD 3 päivässä
(6 arvostelua)
155 $ USD 3 päivässä
(12 arvostelua)

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

55 $ USD 1 päivässä
(19 arvostelua)

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 Lisää

88 $ USD 3 päivässä
(21 arvostelua)

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 Lisää

55 $ USD 1 päivässä
(9 arvostelua)

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 Lisää

50 $ USD 1 päivässä
(9 arvostelua)

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 Lisää

100 $ USD 3 päivässä
(9 arvostelua)
155 $ USD 3 päivässä
(7 arvostelua)
98 $ USD 3 päivässä
(5 arvostelua)

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 Lisää

250 $ USD 3 päivässä
(6 arvostelua)