Mysql pro to check logs and fix mysql cpu usage problem on VPS

In Progress Posted Aug 31, 2014 Paid on delivery
In Progress Paid on delivery

My Website currently has a problem with the mysql queries using way too much CPU. We have a VPS with 6 vCPU's which is more than enough to run the website very fast however recently the site has been freezing due to CPU usage of 91 CPU's.

I need a mysql server technician to look at the logs and fix the mysql problems. you will need to identify what is causing the huge CPU usage and find a solution to fix this and make the mysql efficient.

These are the comments from the server techs where it hosted: "The high load appears to be caused by a build-up of MySQL processes executing this command on the "adultsho_adult" database:

SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c"

We do have a page generation script/system installed that might be the problem but need this investigated.

The website address is attached. You will need to login via a SSH client

you need to write the words "MYSQLPRO" to prove you have read this job and not just made a copy/paste bid.

I will provide login details to winning freelancer.

MySQL Software Testing VPS Website Testing

Project ID: #6395035

About the project

17 proposals Remote project Active Sep 3, 2014