Wordpress PHP/MySQL Spike/Crashing-Optimisation Solution

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 [url removed, login to view] 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.

Taidot: Linux, PHP, verkkosivujen suunnittelu

Näytä lisää: wordpress crashing dedicated server, wordpress us, wordpress system, wordpress services website, wordpress services plugin, wordpress design services, wordpress building services, say media, resolution media, problem wordpress, priority one, plugin wordpress design, php code search mysql database, mysql in memory engine, memory engine, wordpress site keeps crashing, databases wordpress crashing server, mysql optimisation type wordpress, oracle sql help, speed up wordpress, Absolute, wordpress+php, wordpress services, wordpress server, wordpress host

Tietoa työnantajasta:
( 27 arvostelua ) Freeland, United Kingdom

Projektin tunnus: #419445

Myönnetty käyttäjälle:


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

$225 USD 3 päivässä
(19 Arvostelua)

12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


please check PMB. Thanks.

$200 USD 5 päivässä
(147 arvostelua)

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

$300 USD 1 päivässä
(51 arvostelua)

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

$150 USD 0 päivässä
(157 arvostelua)

I can do this

$300 USD 3 päivässä
(46 arvostelua)

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 Lisää

$300 USD 5 päivässä
(8 arvostelua)

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.

$100 USD 3 päivässä
(5 arvostelua)

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

$220 USD 4 päivässä
(0 arvostelua)

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

$150 USD 3 päivässä
(1 arvostelu)

Quality work, kindly check PMB

$150 USD 0 päivässä
(0 arvostelua)

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

$300 USD 1 päivässä
(0 arvostelua)

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

$300 USD 1 päivässä
(0 arvostelua)