Browse categories
Explore
Fiverr Pro
English
$
USD
I will optimize mysql slow queries and design database schemas
About this Gig
Slow queries killing your app? I optimize MySQL databases that serve real products.
WHAT I DELIVER
Slow query analysis EXPLAIN-based diagnosis, rewritten queries, covering-index strategy
Schema design normalized ER models, proper keys and data types, ready-to-run DDL
Index strategy add what's missing, drop what's duplicate, without slowing down writes
Query rewrites bad JOINs, subqueries, N+1 patterns coming from ORMs
Practical caching advice (Redis) so the database stops being the bottleneck
TYPICAL PROJECTS
"This page takes 10 seconds" find the culprit SQL and fix it
New app design the whole schema the right way from day one
Growing tables indexing strategy and, only when truly needed, partitioning guidance
WHAT I NEED FROM YOU
The schema (CREATE TABLE statements) or a dump without private data, the slow queries, and rough table sizes.
I work at the query and schema level I don't need your real data, and I won't touch your servers unless we explicitly agree.
Message me before ordering and I'll tell you exactly which package fits.
Database type:
Relational database
Platform:
MySQL
Expertise:
SQL
•
Performance
FAQ
Do you need access to my production server?
No. Schema definitions + the slow queries + table row counts are enough for offline analysis. Server access only if you explicitly want it.
Do you need my real data?
No — never send private data. Structure is enough.
Can you guarantee a specific speedup?
No honest engineer guarantees a number before seeing the query. I'll report the expected improvement after analysis, with the reasoning.
Which MySQL versions do you cover?
5.7 and 8.x, plus MariaDB. Also general SQL review for PostgreSQL.
