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.



Compétences : MySQL, PHP

en voir plus : mysql reduce cpu load, php optimization 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

Concernant l'employeur :
( 5 commentaires ) KELLYVILLE, Australia

Nº du projet : #1081139

Décerné à:


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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% AUD en 1 jour
(17 Commentaires)

7 freelance font une offre moyenne de $194 pour ce travail


see your pmb please

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(130 Commentaires)

Check PMB for details.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(100 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 15 jours
(12 Commentaires)

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: [login to view URL] to k Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(17 Commentaires)

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 [login to view URL] I can start tonight. Let me know.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)

Please see my message in the clarification board

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)

Hi, please check your pmb for more info.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(0 Commentaires)