OpenCart MySQL Query Optimization

Job ID: 39572157

Budget: $30 – $250 USD

I need an OpenCart specialist to address a MySQL query issue on my OpenCart 3.x website. We're experiencing an excessive number of queries (over 3,000+ per second), disrupting server performance. This surge started suddenly, with no recent updates or changes made on my end. Need to resolve quickly.

Key Requirements:
- Diagnose the root cause of the MySQL query surge.
- Optimize MySQL queries to reduce load on the server.
- Ensure the stability and performance of the OpenCart site post-optimization.

Ideal Skills and Experience:
- Proven experience with OpenCart 3.x.
- Strong expertise in MySQL and database optimization.
- Familiarity with server performance tuning.
- Ability to troubleshoot and resolve complex issues.

Please provide a brief overview of your approach and relevant experience.