Our website has become popular over the past 2 years and the performance over the past few months has become increasingly sluggish. After inquiring with our VPS hosting provider, the conclusion is that MySQL server is overloading the server due to poor PHP code optimization and/or MySQL server setup:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2042 mysql 16 0 1806m 114m 3880 S 319.8 1.9 36427:00 mysqld
We require a professional web professional to analyze our Custom CMS PHP code and MySQL server configuration to optimize for reduced VPS CPU usage.
Our job requirements are as follows:
1) Check and optimize current PHP/MySQL installations
2) Receive and review copy of our CMS files for poor PHP coding which would lead to excessive MySQL CPU usage
3) Make sure both PHP code & MySQL server are optimized for high usage while maintaining optimal load speeds
4) Recommend Optimal VPS Configuration for Best Speeds
Must have PHP, MySQL, server optimization outlined in your reviews & completed work to receive consideration.
Don't bother to apply for project if it's your 1st job. Winning bidder will receive project details upon selection, thank you!
17 freelancers are bidding on average $29/hour for this job
Sometimes is hard to optimize a system, and sometimes is necessary to redo the critical programs. I have experience in that kind of jobs, and I'll be glad to help you.