Terminé

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.

Compétences : Linux, PHP, Design de site internet

en voir plus : 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

Concernant l'employeur :
( 27 commentaires ) Freeland, United Kingdom

Nº du projet : #419445

Décerné à:

TAForrester

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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(19 Commentaires)
6.2

12 freelance font une offre moyenne de $225 pour ce travail

contbd

please check PMB. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(147 Commentaires)
6.6
rahmancbe

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(51 Commentaires)
6.6
Nick1

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(157 Commentaires)
6.2
rshyethmusthafa

I can do this

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(46 Commentaires)
5.2
maketickinc

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(8 Commentaires)
5.7
yumileroy

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
2.9
squareframeindya

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
porcino

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.0
trepp

Quality work, kindly check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
JoffreyMi

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
avadheshkumarpur

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0