MySQL Database Optimization
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.
What I Can Help With
Optimize MySQL queries, indexes and schema for your workload.
Typical Problems
Relevant Experience
Optimized MySQL for backends processing millions of rows daily; familiar with InnoDB tuning, partitioning and read replicas.
What Is Included
How It Works
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.
Starting from €499
Analysis and optimization. Implementation of recommended changes is quoted separately where needed.
Frequently Asked Questions
Online schema changes — any downtime?
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.
Related Services
MySQL Performance Optimization
Optimize MySQL queries, indexes and schema for a production workload.
Backend Performance Audit
Find and prioritize the real bottlenecks across your full backend stack.
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.