I have a website built with PHP/MySQL that receives a high volume of traffic. The site does implement some type of page caching, but it can probably be more optimized to lessen the server load. The server often has very high CPU usage / load balances, and I'm fairly certain it's because the site is not well optimized.
The website is [login to view URL], and it's based on the open-source project called Jobberbase - but customized and modified from that.
Please only bid on this project if you are a PHP/MySQL Expert and have a lot of experience with page caching and website performance optimization.
Thank you.
Have you checked with SQL queries or error log . Often server spike happens because of using unnecessary select from * query when DB is large . Have you noticed any pattern of problem ?