I will optimize slow mysql queries and tune database performance

Chile

I speak Spanish, English

Database Administrator

Senior DBA & Data Engineer with 10+ years of experience optimizing data infrastructure. I specialize in turning slow MySQL and PostgreSQL databases into high-performing systems. I also design robust E...
About this Gig

Is a slow MySQL database dragging down your app's performance? Stop guessing and stacking random indexes. Get a professional, data-driven optimization.

With over 10 years of experience tuning production-critical infrastructure, I transform sluggish MySQL environments into high-performing systems. I don't just fix symptoms; I resolve the root cause of your architectural bottlenecks.

What I can do for you:

  • Advanced Query Tuning: Complete refactoring of complex SELECTs, heavy JOINs, and subqueries.
  • Execution Plan Analysis: Deep dive using EXPLAIN and EXPLAIN ANALYZE to find bad join orders.
  • Strategic Indexing: Designing optimal composite or covering indexes without locking production tables.
  • Slow Query Log Audit: Ranking the heaviest queries impacting CPU and memory.
  • Server Parameter Tuning: Tailoring my.cnf settings (buffer pools, cache sizes) to your hardware.

Why choose me?

  • Senior Expertise: 10+ years of real-world track record in Database Administration.
  • Production-Safe approach: I use schemas and mock data to ensure 100% data safety.

Please contact me before placing an order to discuss your current setup and performance issues.

Expertise:

Query Optimization

Platform:

MySQL