Optimize MySQL 8 queries

Job ID: 37407407

Budget: £20 – £250 GBP

Optimize MySQL 8 queries
- I am currently facing high CPU usage with my MySQL queries.
- I have a specific queries that are causing the issue.
- I can provide the specific query that is causing the issue.

Skills and experience needed:
- Strong expertise in MySQL 8 query optimization.
- Proficiency in analyzing and identifying performance bottlenecks.
- Experience in optimizing queries to reduce CPU usage.
- Familiarity with MySQL 8 and its features.
- Ability to troubleshoot and resolve performance issues efficiently.

Our server FastComet recently upgraded the MySQL version from 5.7 to 8. This is causing our queries, that were running perfectly well, so become really really slow.

We are looking for an expert in MySQL 8, who can optimize these queries.

In your proposal, please share specific examples of optimization for MySQL 8, and the exact amount improved.

If we decide to engage you for this project, payment will only be made after 1 week of checking the serious performance improvements are measured as per CPU usage on our server. Currently CPU is in excess of 60%. After this optimization, we expect CPU usage to be less than 25%.
Related categories: PHP MySQL Database Administration