En cours

MySQL DB/Script Optimization - Reduce CPU Load On Server

Hi There,

I have an Article Directory which uses the ArticleDashboard Script. Site has been running for 4+ years.

Site currently hosted on a VPS account (Hostgator VPS Level 4) and is running extremely slow and the container is constantly using 100%+ CPU.

I have approx 700,000 articles in the directory and 150,000 users. Size of the Mysql database is approaching 3GB.

My hosting company has informed me that the culprit of the high CPU usage is MySQL and this has been confirmed. The [url removed, login to view] file also consumes a fair amount of CPU also as it is being hit during high traffic.

Requirements for this project are as follows:

Isolate the cause of the high CPU load and correct issue (IMPORTANT). It seems as though the database needs to be optimized/modified so that it can run more stable and use far less CPU resources. In doing so, increase the site performance/load time so that users can have a faster response when viewing site. Tweaking of [url removed, login to view] file may be required also.

All modifications need to be documented so that we have a future reference if more work is required later.

Look forward to working with you on this project and hope that you can provide me with the results I need.

Regards,

Mik

Compétences : MySQL, PHP

Voir plus : mysql reduce cpu load, mysql db, php optimization reduce cpu, vps optimization, project optimization, optimization project, mysql index, load time, load php, hosting issue, hostgator, file hosting script, database optimization, php cpu 100, mysql performance optimization, run faster, mysql running, script years, hosting cpu, mysql users, cpu 100, running faster, optimization database, reduce database size, script load

Concernant l'employeur :
( 5 commentaires ) NTH RYDE, Australia

N° du projet : #1081139

Décerné à :

Kotkowiczpl

I work at home. My costs are lower, prices more competitive and my workplace is idealy suited to my needs. I have been working remotely for years and I believe this is an ideal solution. I profess the mutual trust prin Plus

140 $ AUD en 1 jour
(17 Commentaires)
5.0

7 freelance ont fait une offre moyenne de 194 $ pour ce travail

dracco

see your pmb please

200 $ AUD en 2 jours
(130 Commentaires)
5.8
devservice

Check PMB for details.

250 $ AUD en 7 jours
(100 Commentaires)
5.7
lastguru

Greetings.. ********************************.. YOUR SEARCH ENDS HERE .. ******************** we have proven again and again our ability to develop quality products on-time and on-budget without sacrificing quality. Plus

250 $ AUD en 15 jours
(12 Commentaires)
5.5
cedricve

Hey sir, Ì'm highly intrested in your project and have experience with very large databases. I can help solving your problem and optimizing your CPU load. Please check out my personal page: www.cedricve.me to k Plus

150 $ AUD en 0 jours
(17 Commentaires)
4.5
craigmaria

Hi, I run an Australian Web Hosting company and totally understand your issue and would be more than happy to help you out with this. Check out my site craigmaria.com I can start tonight. Let me know.

165 $ AUD en 5 jours
(0 Commentaires)
0.0
simpleh123

Please see my message in the clarification board

150 $ AUD en 2 jours
(0 Commentaires)
0.0
umtdevpro

Hi, please check your pmb for more info.

250 $ AUD en 4 jours
(0 Commentaires)
0.0