Mysql pro to check logs and fix mysql cpu usage problem on VPS
$30-250 AUD
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.
Project ID: #6395035