MySQL Performance Optimization
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.
What I Can Help With
Optimize MySQL queries, indexes and schema for a production workload.
Typical Problems
Relevant Experience
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.
What Is Included
How It Works
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.
Starting from €399
Analysis and a written set of prioritized recommendations. Implementation of changes is quoted separately.
Frequently Asked Questions
Will adding indexes lock my tables?
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.
What output do you need?
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.
Related Services
Backend Performance Audit
Find and prioritize the real bottlenecks across your full backend stack.
PHP Performance Optimization
Profile and optimize PHP applications that are slow, memory-heavy or consuming too much CPU.
Systems I've Built
Cenoskop / Levnobot
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.
Niftycent
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.
AnalyticsForWebsite
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.
Not sure what's wrong?
Write what's happening and paste anything relevant — errors, logs, metrics. I'll have a look and tell you what I think.