You have chosen to sponsor your bid up to a maximum amount of .
We are running a mysql heavy front end of a website on a dedicated server with following specs
2x120G SSD disks on RAID-1
Dual E5620 @2.40GHz
We seems to get lot of CPU usage by MySQL process during peak hours and this seems to result in a really slow site loading time during the peak. I have attached an #atop screenshot when this issue is happening.
I am looking to hire someone to fix this issue.
1. Either by optimizing mysql/server configuration
2. Or by providing detailed instructions to script vendor on how to optimize their mysql queries.a