Project Detail

Wordpress PHP/MySQL Spike/Crashing-Optimisation Solution

Wordpress PHP/MySQL Spike/Crashing-Optimisation Solution is project number 419445
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: TAForrester

Budget: max $300

Created: 04/16/2009 at 6:32 EDT

Bid Count: 12

Average Bid:
$ 225

04/17/2009 at 6:32 EDT

Project Creator: drrobfisher
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (12 reviews)

Description

I have a Wordpress site which contains 1600+ pages: all text, no multi-media. The site is hosted on a dedicated server, the CPU is a 2x Intel Xeon 2.80GHz with a memory of 2x 512MB DDR1 ECC RE and a Hard Drive of 1x 73GB SCSI HDD. Operating System: Linux. Server panel: Plesk.

Problem: the site keeps crashing the server; I am told that 'sql spikes' are the cause, 'bad code' using php to process sql services and/or keeping sql services open too long, thereby building up more processes leading to the spike and the crash. They also say our sql queries are extremely inefficient.

On previously advertising this problem, a rogue Wordpress plugin was identified and removed. This improved the situation. The host originally limited us to 35 concurrent connections in an effort to maintain stability, along with disabling any search engine robots from trawling the site. The number of connections was then raised to 75. However, the site started crashing again on re-admiting search robots - again, bad sql optimisation and poor php code is being blamed.

I urgently need some one to analyze and solve this problem please, looking specifically at the php and database aspects of the problem. I am a not-for-profit and speed of resolution is an absolute priority.

Report Violation

Job Type

See more: advertising, building, code, database, dedicated, dedicated server, host, number, open, php, plugin, search, search engine, server, site, sql, wordpress, wordpress plugin

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

150

0 days

04-16-2009 11:48 EDT

9.9938/10
(162 reviews)

Certified Linux System Administrator ready to work. I can start right away. Kindly check my PM. Regards. Nick.

contbd

200

5 days

04-16-2009 07:22 EDT

9.9714/10
(105 reviews)

please check PMB. Thanks.

rshyethmusthafa

300

3 days

04-16-2009 07:37 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(46 reviews)

I can do this

TAForrester

225

3 days

04-16-2009 10:05 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(24 reviews)

Hello, Please see PM for bid details. Thank you, Thomas

rahmancbe

300

1 day

04-16-2009 07:07 EDT

9.8235/10
(17 reviews)

Dear Sir, I like to associate with you in this project.

yumileroy

100

3 days

04-16-2009 08:50 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(6 reviews)

Hi drrobfisher, I am very confident of fixing this problem. From what I see, your Wordpress blog is very big, I will try my very best to fix it. I can fix it in 1-3 days to be realistic.

squareframeindya

220

4 days

04-16-2009 06:49 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Hi We are confident to do the project, we having good setup and efficient manpower to complete this project within the mention time line. Please find PMB for more. Regards with Dev

maketickinc

300

5 days

04-16-2009 09:59 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Hi Sir/Madam, Greetings from Maketick, Inc. We are an organization empowered with 50+ professionals Senior Graphics designers, Solutions Architect, Software Engineers, Project Managers etc. We are based in Silicon Valley, USA are available anytime you need us. We have extensive experience working on various kinds of websites. We expertise in the field of designing and programming for different simple and complicated web projects. We have long years of experience in PHP and other open source technologies. Please view our portfolio (posted in the pmb). We assure you world-class services at the most affordable and economic, yet competitive, prices. PLEASE VIEW PMB FOR MORE DETAILS. Thanks and best regards, PS, Maketick Inc.

porcino

150

3 days

04-16-2009 07:03 EDT

(No Feedback Yet)

Hi I have had a case like yours, Spam and Denial of Service. Can help solve the problem

trepp

150

0 days

04-16-2009 09:05 EDT

(No Feedback Yet)

Quality work, kindly check PMB

JoffreyMi

300

1 day

04-16-2009 08:42 EDT

(No Feedback Yet)

Hi, I'm expert on webplatforms performance. Contact me via MP if interested. Preferred currency : Euro Rds, Joffrey

avadheshkumarpur

300

1 day

04-16-2009 10:52 EDT

(No Feedback Yet)

Lets Start...You give me problem i will give you solution...

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.