Help setting up MySQL queries properly for opencart
Budget: $20 – $50 USD
We need help setting up MySQL queries properly. We have transferred our working project of the online store https://digimarket.co.il/ on the opencart script to the new hostinger.com hosting.
The transfer was successful, the transferred base is connected.
But there was a problem, at the moment when we go to the site admin panel to work - the server starts showing CPU usage up to 100% and naturally the site stops working on both sides - both the user and the admin ...
There is a server usage log, by which you need to determine which MySQL queries lead to the exhaustion of server limits.
It is necessary to check them and optimize such requests in order to avoid high load on the server.
The transfer was successful, the transferred base is connected.
But there was a problem, at the moment when we go to the site admin panel to work - the server starts showing CPU usage up to 100% and naturally the site stops working on both sides - both the user and the admin ...
There is a server usage log, by which you need to determine which MySQL queries lead to the exhaustion of server limits.
It is necessary to check them and optimize such requests in order to avoid high load on the server.