Our website is taking a lot of resources on the server. The server told us that
The memory on the server is not being used very much, and the Disk IO is normal. However there is a lot of CPU load from Mysql which is showing a large number of long running queries from the site. This is normally caused by un-optimized mysql queries taking up a lot of cpu power.
We need your help to review the code on the site and optimize the mysql queries.
Our previous programmer did the website php on the kohana framework.