[WHM] MySql is using 100% CPU

Job ID: 31032658

Budget: $10 – $30 USD

Hi
Our website is made in PHP, uses PHP 5.6 and we cannot update it because the site is old.

The DB is MySQL, a select query is crashing the processor to the point of marking almost 400% of use, I need someone who can diagnose and solve the problem.

I need an PHP and MySql expert.

I have attached some screenshots to help you get your bearings.
Related categories: PHP System Admin Linux Apache MySQL