Looks Like This Service Is On Hold

I will audit and fix your mysql performance and backend bugs

L
lingguiqian
L
lingguiqian
Guiqian L

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

Guiqian L

Backend Engineer

  • FromChina
  • Member sinceOct 2026
  • Languages

    Chinese, English
Backend engineer (Go / Java / Spring Boot) focused on correctness under load. • Data infra — realtime WebSocket ingestion, idempotent incremental backfill, large MySQL datasets • Backend — REST APIs, order and payment flows, Redis locking/caching, Docker deployment • AI integration — model APIs behind one async pipeline with cache, retry and fallback Proof: a marketplace backend I built solo (20+ tables, 60+ APIs) held 500 QPS in load tests with zero order-state anomalies. Async-first, UTC+8, 20 h/week. Tell me the problem — I'll reply with an approach and a price.

My Portfolio