fix MySQL cpu usage is over 200% ~ 500%

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I have Dedicated Linux Server

Hardware:

Ram: 32GB

Hard: 250 SSD

CPU: Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz

Connection: 1Gbit

OS: Ubuntu 16.0.4 64Bit

Installed apps:

MySQL 5.7

Apache 2

PHP 7

MongoDB

NodeJs

my max Online is: 40

my max connection on MySQL is: 250

i dont have slow query

i have one website on this server.

MySQL Tables is innoDB.

but MySQL CPU USAGE is over 200% ~ 500%

i need fix this problem and Optimization my Server.

Database Administration Linux MySQL System Admin Ubuntu

Project ID: #15409801

About the project

16 proposals Remote project Active 6 years ago

16 freelancers are bidding on average $48 for this job

vili1977

fix overloading issue Relevant Skills and Experience mysql php apache nginx Proposed Milestones $25 USD - fix mysql overloading

$25 USD in 1 day
(783 Reviews)
7.4
kuldeepvk

Hi, I will check CPU usage and fix it and optimize server too. thank you Relevant Skills and Experience 8 years of experience. Proposed Milestones $30 USD - I will check CPU usage and fix it and optimize server too More

$30 USD in 1 day
(356 Reviews)
7.0
codetrance

Server optimization Relevante Vaardigheden en Ervaring Linux, system admin Voorgestelde Milestones $45 USD - Server optimization

$45 USD in 1 day
(185 Reviews)
6.5
amcorreia

Hi there provide more details about your server Habilidades e Experiência Relevantes linux mysql Pré-pagamentos Propostos $111 USD - optimize

$111 USD in 2 days
(116 Reviews)
6.5
RWHTech

Looks like mysql is stock, so my bid includes an upgrade to MariaDB and optimizing it, which will bring CPU usage down to saner levels. Relevant Skills and Experience I run a web hosting service and have extensive ser More

$75 USD in 1 day
(210 Reviews)
6.5
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 yes More

$34 USD in 0 days
(125 Reviews)
5.8
redssr

Are you using the default config for mysql or its customized. what does the output of iotop or sar cmd gives. Relevant Skills and Experience About myself https://www.freelancer.com/u/redssr.html Proposed Milestones More

$25 USD in 3 days
(120 Reviews)
5.2
zMinion

Hello, I can fix your mysql server configuration, most likely is a bad cnf but that require some testing and that can't be done in minutes (1-2days min.) Relevant Skills and Experience I work as a system admin for an More

$150 USD in 5 days
(31 Reviews)
5.4
chiragdosi

I am Red Hat Certified Linux Engineer and having 5+ year of experience in Managing Core Server | Dedicated Server | VPS Server. I will help you in optimizing your server and fixing all problems. Relevant Skills and Ex More

$25 USD in 1 day
(35 Reviews)
5.0
vinaysinghh

i am mysql dba having more then 7 yrs of exp Relevant Skills and Experience mysql Proposed Milestones $25 USD - mysql

$25 USD in 1 day
(56 Reviews)
5.4
NurulKadir

Hi Dear, I can fix your CPU uses issue. I am a Linux System Administrator and CakePHP web programmer. right now i am maintaining mobile operatpr Datanase Server. Relevant Skills and Experience Apache and MySQL perform More

$35 USD in 1 day
(8 Reviews)
4.2
tommanning1982

Hi, I have over 8 years of experience in Linux/Unix administration especially Server setup, Security audit, hardening and Server optimization. Relevant Skills and Experience RHEL-4,5,6,7/CentOS-6,7, Debian, Ubuntu, More

$35 USD in 1 day
(11 Reviews)
4.6
tsymbalyukivan

I'm working in hosting company as Linux administrator 10 years, therefore I can help you with your task. Важливі навички та досвід vps, Linux system administrator Запропоновані поетапні платежі $50 USD - for fix cpu More

$50 USD in 1 day
(16 Reviews)
3.7
akthar1992

/ Relevant Skills and Experience . Proposed Milestones $25 USD - . .

$25 USD in 1 day
(0 Reviews)
0.0
mefish

A proposal has not yet been provided

$15 USD in 1 day
(1 Review)
0.0