Exceeding the limits of requests to the database on the OpenCart 2.3 site

Looking for a specialist to resolve issues with exceeding database query limits (ocStore / OpenCart 2.3)

Problem description:

There is a site on ocStore (OpenCart 2.3) that periodically stops working due to exceeding the database query limit.

The last received error message:
Warning: mysqli::set_charset(): Error executing query in /var/www/atlantika.biz/data/www/atlantika.biz/system/storage/modification/system/library/db/mysqli.php on line 13  

Fatal error: Uncaught Exception: Error: User 'konstadw_steroid' has exceeded the 'max_questions' resource (current value: 500000)  

Error No: 1226  

Usually, after Error No: 1226, a series of paths are described each time, which can vary each time.

The problem may be related to a large number of requests from the site itself or suspicious activity (spam attacks).

Tasks:

1. Diagnosis of the problem

   • Analyze the cause of exceeding the database query limits.
   • Provide an explanation of why this is happening and what causes this problem.
   • Suggest solutions.

2. Database and query optimization

   • Eliminate the problem to prevent it from recurring.
   • Optimize queries if necessary (e.g., caching, indexing, reducing load).

3. Protection against bots / spam requests

   • Check if there is increased load on the site due to spam requests or bot attacks.
   • If so, suggest effective protection methods.
   • Possible solutions: blocking access from other countries (except Ukraine), CAPTCHA, firewall, etc.

4. Precautions for the future

   • Suggest additional improvements for the stable operation of the site.
   • Implement monitoring mechanisms to quickly detect and resolve issues.

What we need from you:

• Approximate timeline
• Cost of work (can be broken down into stages).

What we will provide:

• All necessary access.
• Prompt feedback.
• Payment after agreeing on all details.

 
Ideally, it would be good to make prompt changes to prevent the site from going down, after which further analysis can be conducted.