MySQL / Concurrency, performance, and operations

MySQL β€” Concurrency, performance, and operations

Diagnose contention and plan sustainable performance, document contracts, and recovery.

6 lessons Β· No account required

What you will learn

  • Recover deadlock victims with bounded safe retries.
  • Assess optimizer evidence, JSON and routines, restore readiness, and GTID-aware operations.

  1. Locking, waits, and deadlock recovery

    Reason about concurrent lock ownership and recover a complete business operation within bounded retry limits.

    Start learning

  2. Optimizer evidence and sustainable performance

    Improve a query family using representative cardinalities, bounded work, and write-aware index choices.

    Start learning

  3. JSON and relational boundaries

    Use flexible documents where they fit while keeping typed identities, relationships, and query paths explicit.

    Start learning

  4. Stored routines, handlers, and responsibility

    Design small stored programs with clear validation, security, and transaction ownership.

    Start learning

  5. Backup, restore, and point-in-time recovery

    Design recovery around explicit loss and downtime objectives, then verify a restored database rather than trusting a file.

    Start learning

  6. Replication, GTIDs, and operational readiness

    Separate replication progress, availability decisions, and recovery responsibilities.

    Start learning
Back to course