Looks Like This Service Is On Hold
I will audit and fix your mysql performance and backend bugs


About this gig
Your system got slow, or your numbers stopped matching. I find the cause, fix the top few, and show the evidence: query plans, indexes, the state machine below.
What I've done, with real numbers:
- Owned a marketplace's whole order, dispatch and settlement flow: 20+ tables, 60+ REST APIs
- Load-tested an order state machine to 500 QPS with zero state anomalies (Redis lock + row-level optimistic locking)
- Settlement as an append-only ledger, so any balance can be recomputed for reconciliation
- Large-table MySQL work: schema and index decisions driven by the actual query plan, not by habit
What you get:
- A short findings list, prioritised by impact (usually 2-4 things that actually matter)
- The fixes themselves: indexes, query rewrites, lock scope, transaction boundaries
- Before and after numbers (EXPLAIN output, timings), so you can see what changed
- For concurrency bugs: the invariant that broke, and the test that keeps it fixed
What I need: the schema for the tables involved, the slow queries or the failing flow, and your EXPLAIN output.
Not a fit if you need a 24/7 on-call DBA, or work on a trading system or trading strategies - I do not take that.
Get to know Guiqian L
Backend Engineer
- FromChina
- Member sinceOct 2026
Languages
Chinese, English
My Portfolio
FAQ
Do you need access to my database
A Ideally yes, and a read-only user is enough for diagnosis. If that is not possible, a schema dump plus your EXPLAIN output gets me most of the way, and I will tell you what else I need.
Which databases and stacks do you cover?
MySQL and MariaDB are what I know best (5.7 and 8.x). Backend side: Java (Spring Boot) and Go, with whatever ORM or raw SQL you use.
How do you charge for the fixes?
Flat packages: Basic covers one slow query end to end. If the real cause turns out to be much bigger than the package, I will say so before starting, not after.
Will you touch my production database?
No. I hand you SQL and code changes to apply, or I apply them on a staging copy. Nothing runs against production without your explicit go-ahead.

