Đã Hủy

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]

Kỹ năng: Linux, MySQL, SQL, Quản trị hệ thống

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) Fort Worth, United States

Mã Dự Án: #14811463

28 freelancer đang chào giá trung bình $106 cho công việc này

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 trong 1 ngày
(105 Đánh Giá)
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 trong 1 ngày
(170 Đánh Giá)
6.4
dkokmadis

A proposal has not yet been provided

$72 USD trong 3 ngày
(235 Đánh Giá)
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 Thêm

$244 USD trong 4 ngày
(141 Đánh Giá)
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 Thêm

$60 USD trong 1 ngày
(117 Đánh Giá)
5.9
$50 USD trong 3 ngày
(150 Đánh Giá)
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 trong 1 ngày
(80 Đánh Giá)
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 trong 3 ngày
(82 Đánh Giá)
5.2
vinaysinghh

I am mysql dba having more then 10 yrs of experience

$110 USD trong 2 ngày
(43 Đánh Giá)
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+ Thêm

$72 USD trong 0 ngày
(34 Đánh Giá)
4.6
$155 USD trong 3 ngày
(6 Đánh Giá)
4.6
$155 USD trong 3 ngày
(12 Đánh Giá)
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 trong 1 ngày
(19 Đánh Giá)
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 Thêm

$88 USD trong 3 ngày
(21 Đánh Giá)
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 Thêm

$55 USD trong 1 ngày
(9 Đánh Giá)
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 Thêm

$50 USD trong 1 ngày
(9 Đánh Giá)
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 Thêm

$100 USD trong 3 ngày
(9 Đánh Giá)
3.5
$155 USD trong 3 ngày
(7 Đánh Giá)
3.5
$98 USD trong 3 ngày
(5 Đánh Giá)
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 Thêm

$250 USD trong 3 ngày
(6 Đánh Giá)
3.0