Tune MYSQL on apache server

Job ID: 32889386

Budget: $30 – $250 USD

I need to tune mysql process as it is using too much CPU when I have above 25 visitors
we need to find the bad queries

using:
CentOS v7.9.2009
apache server
php-rpm
Prestashop 1.7

Related categories: Prestashop MySQL Database Management Performance Tuning