Đã hoàn thành

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.



Kĩ năng: MySQL, PHP

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) KELLYVILLE, Australia

ID dự án: #1081139

Được trao cho:


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 Thêm

$140 AUD trong 1 ngày
(17 Đánh Giá)

7 freelancer đang chào giá trung bình $194 cho công việc này


see your pmb please

$200 AUD trong 2 ngày
(130 Nhận xét)

Check PMB for details.

$250 AUD trong 7 ngày
(100 Nhận xét)

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. Thêm

$250 AUD trong 15 ngày
(12 Nhận xét)

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: [url removed, login to view] to k Thêm

$150 AUD trong 0 ngày
(17 Nhận xét)

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

$165 AUD trong 5 ngày
(0 Nhận xét)

Please see my message in the clarification board

$150 AUD trong 2 ngày
(0 Nhận xét)

Hi, please check your pmb for more info.

$250 AUD trong 4 ngày
(0 Nhận xét)