Queries that used to be fast now scan half the table, inserts lock for seconds, and the database CPU is pinned. I review your MySQL configuration, indexes and queries, and fix what's actually slow.
I work against your data volume, not generic advice — using EXPLAIN, pt-query-digest, the slow query log and schema analysis to find what matters for your workload.
Optimize MySQL queries, indexes and schema for a production workload.
Optimized MySQL for Cenoskop — a product database with millions of rows where query times went from seconds to milliseconds after adding covering indexes and rewriting three JOIN-heavy queries. Also tuned InnoDB buffer pool and query cache for the specific workload.
You share the slow query log (or a pt-query-digest report), EXPLAIN for the slowest queries, and SHOW CREATE TABLE output. I identify the worst queries by impact, find the missing or suboptimal indexes, check for schema issues, and implement or recommend fixes. Most engagements take a few hours to a day.
Analysis and a written set of prioritized recommendations. Implementation of changes is quoted separately.
For large InnoDB tables I use pt-online-schema-change or native online DDL so writes keep flowing. I'll confirm the approach for your version and size before doing anything.
The slow query log (or a pt-query-digest report), EXPLAIN for the slowest queries, and your SHOW CREATE TABLE output. I can also read from a replica if preferred.
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.