Closed

fix MySQL cpu usage is over 200% ~ 500%

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.

Skills: Database Administration, Linux, MySQL, System Admin, Ubuntu

See more: mysql high cpu usage windows, mysql high cpu usage linux, mysql cpu usage optimization, mysql high cpu usage centos, how to check cpu utilization in mysql, mysql high cpu no queries, mysql cpu usage query, mysql cpu utilization high, fix mysql cpu load issue, fix mysql cpu, mysql cpu usage copying tmp table, mysql cpu usage 100 linux, reduce mysql cpu usage, cpu usage 200, max mysql cpu usage, lower php mysql cpu usage, troubleshoot mysql cpu usage, debian mysql cpu usage, tune mysql cpu usage, mysql cpu usage quad

About the Employer:
( 0 reviews ) France

Project ID: #15409801

18 freelancers are bidding on average $46 for this job

codetrance

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

$45 USD in 1 day
(174 Reviews)
6.5
vili1977

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

$25 USD in 1 day
(437 Reviews)
6.7
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
(113 Reviews)
6.4
$61 USD in 1 day
(186 Reviews)
6.1
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
(172 Reviews)
6.2
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
(110 Reviews)
5.9
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
(15 Reviews)
4.6
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
(46 Reviews)
4.9
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
(44 Reviews)
5.3
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
(10 Reviews)
4.6
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
(35 Reviews)
4.3
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
(19 Reviews)
4.5
crazyunix

i can check it for u afterthat i will tell u what u should do and where is the problem Relevant Skills and Experience im php and linux developer Proposed Milestones $35 USD - project fee

$35 USD in 1 day
(20 Reviews)
4.1
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
(6 Reviews)
3.5
sukritimehta1111

As per my experience in handling projects on freelancer I can assure you that I can easily do this task. Moreover, you can check my reviews to get a prior knowledge about my accomplishments. Relevant Skills and Experi More

$25 USD in 1 day
(2 Reviews)
1.7
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
(2 Reviews)
1.6
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