Same goal as MySQL performance optimization, different entry point: you have a specific database or set of queries that need tuning, and you want the index/schema/query fixes applied to your system.
I review your MySQL configuration, indexes and queries, and optimize them for your actual data volume and workload.
Optimize MySQL queries, indexes and schema for your workload.
Optimized MySQL for backends processing millions of rows daily; familiar with InnoDB tuning, partitioning and read replicas.
You share slow-log/EXPLAIN output and schema, or grant read-only access. I identify the worst queries and apply or recommend the right indexes and schema changes. Typically a few hours to a day.
Analysis and optimization. Implementation of recommended changes is quoted separately where needed.
For large InnoDB tables I use pt-online-schema-change or native online DDL so writes keep flowing. I'll confirm the approach before doing anything.
Other problems I help with.
Relevant production work.
Crawler monitoring millions of products. Processing 30M products daily and comparing them.
Built and maintain the full crawling pipeline — from scraping through Elasticsearch indexing to price comparison.
Price intelligence engine for the US market. Processing large-scale product data.
Built the data pipeline and crawling infrastructure for large-scale US product monitoring.
Custom solution for collecting and evaluating traffic metrics with emphasis on processing speed and minimizing backend load.
Designed and built the backend for fast traffic metric collection and evaluation.
Describe the problem in a few lines — I'll look at it and tell you what I think.