İptal Edildi

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: [url removed, login to view]

Here's a screenshot of the Process Manager.

[url removed, login to view]

Beceriler: Linux, MySQL, SQL, Sistem Yöneticisi

Daha fazlasını görün: 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, migrate standalone mysql cpanel, copy mysql cpanel, transfer mysql cpanel domain, reinstall mysql cpanel, perl mysql cpanel, separate mysql server cpanel, cpanel mysql backup script

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #14811463

28 freelancer bu iş için ortalamada 106$ teklif veriyor

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?

1 gün içinde 111$ USD
(105 Değerlendirme)
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?.

1 gün içinde 60$ USD
(170 Değerlendirme)
6.4
dkokmadis

A proposal has not yet been provided

in 3 gün içinde72$ USD
(235 Değerlendirme)
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 Daha fazlası

in 4 gün içinde244$ USD
(141 Değerlendirme)
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 Daha fazlası

1 gün içinde 60$ USD
(117 Değerlendirme)
5.9
in 3 gün içinde50$ USD
(150 Değerlendirme)
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.

1 gün içinde 88$ USD
(80 Değerlendirme)
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

in 3 gün içinde77$ USD
(82 Değerlendirme)
5.2
vinaysinghh

I am mysql dba having more then 10 yrs of experience

in 2 gün içinde110$ USD
(43 Değerlendirme)
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+ Daha fazlası

in 0 gün içinde72$ USD
(34 Değerlendirme)
4.6
in 3 gün içinde155$ USD
(6 Değerlendirme)
4.6
in 3 gün içinde155$ USD
(12 Değerlendirme)
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

1 gün içinde 55$ USD
(19 Değerlendirme)
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 Daha fazlası

in 3 gün içinde88$ USD
(21 Değerlendirme)
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 Daha fazlası

1 gün içinde 55$ USD
(9 Değerlendirme)
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 Daha fazlası

1 gün içinde 50$ USD
(9 Değerlendirme)
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 Daha fazlası

in 3 gün içinde100$ USD
(9 Değerlendirme)
3.5
in 3 gün içinde155$ USD
(7 Değerlendirme)
3.5
in 3 gün içinde98$ USD
(5 Değerlendirme)
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 Daha fazlası

in 3 gün içinde250$ USD
(6 Değerlendirme)
3.0