aneasystone/mysql-deadlocks resource
收集一些常见的 MySQL 死锁案例 observed · 2026-08-28
Health v2 · maintenance only
32/100
- Activity 0
- Release rhythm 35
- Longevity 100
Flags: no_releases no_license
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 3082
- days_rel: n/a
- days_push: 2234
- n_releases_24m: 0
Adoption not part of the score
1492 stars · 323 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
A curated collection of common MySQL deadlock cases, each analyzed from deadlock logs with reproduction steps, table schemas, and explanations of the locks involved. Cases are classified by the SQL statements each transaction executes and the locks they wait for or hold.
Use cases
- understand why two inserts caused a deadlock in MySQL
- analyze InnoDB deadlock log output
- reproduce a gap lock deadlock scenario
- learn how insert intention locks and gap locks interact
- troubleshoot 'lock_mode X locks rec but not gap' errors
- study real-world MySQL transaction locking examples
When to choose
- debugging or preventing MySQL/InnoDB deadlocks
- learning how InnoDB row, gap, and intention locks work
- training database engineers on concurrency issues
When to avoid
- you need deadlock handling for PostgreSQL, SQL Server, or other databases
- you want an automated deadlock detection or resolution tool
- you need actively maintained, up-to-date content
Facets
learning-resource · maturity maintenance
database documentation databases tutorials developer-tools mysql deadlock innodb locking case-studies database-internals chinese
1 source
- readme: https://github.com/aneasystone/mysql-deadlocks · fetched 2026-08-28 · e6cab0eee9f2
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| aneasystone/mysql-deadlocks | main | 32 |
For agents
markdown · JSON · MCP: product_card(name="aneasystone/mysql-deadlocks")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem