Annulé

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]

Compétences : Linux, MySQL, SQL, Administration Système

Voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Fort Worth, United States

N° du projet : #14811463

28 freelance ont fait une offre moyenne de 106 $ pour ce travail

amcorreia

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 en 1 jour
(105 Commentaires)
6.3
codetrance

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 en 1 jour
(170 Commentaires)
6.4
dkokmadis

A proposal has not yet been provided

72 $ USD en 3 jours
(235 Commentaires)
6.4
tlchung

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

244 $ USD en 4 jours
(141 Commentaires)
6.0
RWHTech

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

60 $ USD en 1 jour
(117 Commentaires)
5.9
50 $ USD en 3 jours
(150 Commentaires)
5.5
kuldeepvk

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 en 1 jour
(80 Commentaires)
5.6
nizamec2012

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 en 3 jours
(82 Commentaires)
5.2
vinaysinghh

I am mysql dba having more then 10 yrs of experience

110 $ USD en 2 jours
(43 Commentaires)
5.1
sumitmakkar

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

72 $ USD en 0 jours
(34 Commentaires)
4.6
155 $ USD en 3 jours
(6 Commentaires)
4.6
155 $ USD en 3 jours
(12 Commentaires)
4.3
Gauravsingh9828

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 en 1 jour
(19 Commentaires)
4.1
Walrusyn

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

88 $ USD en 3 jours
(21 Commentaires)
3.8
infihost

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

55 $ USD en 1 jour
(9 Commentaires)
3.6
L1Ntu

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

50 $ USD en 1 jour
(9 Commentaires)
3.3
hemantjhalani

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

100 $ USD en 3 jours
(9 Commentaires)
3.5
155 $ USD en 3 jours
(7 Commentaires)
3.5
98 $ USD en 3 jours
(5 Commentaires)
3.1
Dckumawat

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

250 $ USD en 3 jours
(6 Commentaires)
3.0