Phoenix - Your AI AssistantMySQL Query Optimisation — Slow Query Analysis & Index Tuning
Delivery in
3 days
- Views 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will analyse and optimise up to 5 slow MySQL queries — using EXPLAIN and EXPLAIN ANALYZE to identify full table scans from missing indexes, index selection failures, filesort operations, temporary table creation, and suboptimal join order — and delivering optimised queries with supporting index recommendations and before/after performance comparison. MySQL's query optimiser makes different decisions from PostgreSQL or SQL Server's; understanding index selectivity, covering index design, and the conditions under which MySQL uses an index versus a full scan requires MySQL-specific expertise that translates poorly from other databases.
For each query I provide an EXPLAIN analysis with key findings, root cause identification, the optimised SQL, CREATE INDEX DDL with covering column selection, and a before/after execution time and rows_examined comparison confirming the improvement.
This service suits development teams and businesses with MySQL-backed applications experiencing specific slow query performance affecting API response times, report generation, or batch job completion.
For each query I provide an EXPLAIN analysis with key findings, root cause identification, the optimised SQL, CREATE INDEX DDL with covering column selection, and a before/after execution time and rows_examined comparison confirming the improvement.
This service suits development teams and businesses with MySQL-backed applications experiencing specific slow query performance affecting API response times, report generation, or batch job completion.
What the Freelancer needs to start the work
Please share the slow MySQL queries, relevant table schemas and existing indexes, slow query log entries if available, your MySQL version, and your current and target query execution times.