Mysql Server overload

Closed

Description

We have wordpress website with around 100k posts.

It is hosted on a dedicated server with a quad processor and 8gb memory. From time to time the server freezez and overloads.

It seems to be due to mysql overloading and using most of the CPU.

I am looking for a mysql and Centos guru to find out what is causing this issue and resolve it.

Skills: Database Administration, MySQL, PHP, SQL, UNIX

See more: mysql server overload, server guru, guru server, find-guru, find a guru, sql mysql, sql guru, mysql and sql, memory overload, server 2012 wordpress, resolve server, server issue, mysql overload server, centos wordpress, wordpress dedicated server overload, mysql wordpress cpu overload, cpu time, 100k website, resolve issue, memory centos, mysql dedicated server, hanil405, centos mysql dedicated server, dedicated mysql, php cpu overload

Project ID: #1481849

Awarded to:

jivchik

I can help to optimize mysql. Details in PMB

$60 USD in 2 days
(8 Reviews)
3.2

18 freelancers are bidding on average $100 for this job

stels88

I can help you!

$120 USD in 2 days
(157 Reviews)
6.4
keiespro

Hello. I know what to do .

$100 USD in 0 days
(124 Reviews)
6.3
triamazikamno

Professional server/website optimizer with 14 years *nix experience.

$150 USD in 2 days
(52 Reviews)
6.3
hvtuananh

Please check your PMB

$100 USD in 3 days
(128 Reviews)
6.1
nknk

Hi. That's my specialty. Please check PM.

$120 USD in 5 days
(62 Reviews)
5.9
GuruDeveloper

12 years of experience in Linux & MySQL. I'm ready to help you.

$99 USD in 3 days
(22 Reviews)
5.6
codetrance

I've extensive knowledge about Linux server administration. I can help you. Thank you.

$80 USD in 1 day
(51 Reviews)
5.4
SiMka85

Hi! Ready to start!

$100 USD in 1 day
(26 Reviews)
4.6
brND

I have enough experience with troubleshooting mysql tuning and can do it fast for you.

$90 USD in 2 days
(15 Reviews)
4.5
slk

Please see PMB.

$99 USD in 2 days
(8 Reviews)
4.0
splourde

Hi, I'm a Linux system administrator and I already did several similar projects. I can start right away!

$100 USD in 1 day
(10 Reviews)
3.5
tommanning1982

I can find and fix this issue. Please check your PM. :)

$85 USD in 1 day
(5 Reviews)
3.1
kyrianUK

Hiya, I'm assuming this is hosted on a Linux (LAMP) system. I'm a linux systems administrator and PHP web developer with 15+ years experience, and I've seen this problem before loads of times. I've saved a custom More

$200 USD in 3 days
(5 Reviews)
3.0
nadimco

Hi. I think the best way is to host mysql-server on another server, and configure local cache. I think it's the best way.

$75 USD in 2 days
(1 Review)
1.7
spymodem

This is seriously too easy... I can take care of this for you no problem. I'll even harden the security on your server at no extra charge.

$100 USD in 1 day
(0 Reviews)
0.0
Cueva51

Higher quality & good reputation service always!!! De-Captcha Service Available 10,000 Credit Price $20 20,000 Credit Price $35 50,000 Credit Price $80 1,00,000 Captcha Credit Price $150 Account Creatin More

$30 USD in 1 day
(0 Reviews)
0.0
himapurohit

Allow me to undertake this project and the work would speak by itself.

$111 USD in 7 days
(0 Reviews)
0.0
mjaniszewski

I have ten years experience in the administration of Linux servers. I can help you with tweaking your server.

$79 USD in 2 days
(0 Reviews)
0.0