mysql-internals skillA
mysql-internals is agent-read markdown (skill) from yuecao365/offercome: 数据库深挖：索引与存储结构、事务与 MVCC、锁与死锁、执行计划、复制与高可用、分库分表、NoSQL 选型。.
Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.
What the file says
## 面试官在意什么 数据库是后端面试里最容易问深、最能分出层次的一块：从"加个索引"到"页分裂与 change buffer"，从"用事务"到"ReadView 与 undo 版本链"。面试官从业务现象切入（慢查询、死锁、主从延迟、误删、连接池耗尽），追到机制层；DBA 与内核岗再往存储引擎与优化器追。2026 年新增的追问是向量与全文检索进关系库（pgvector 之类）该不该用、什么规模顶不住。 ## 项目 / 实习怎么深挖 简历上出现下面这类经历时从哪里切、追什么。追到候选人能说出机制、数字的来源与一次真实的故障或取舍才算实；只有框架名与结论、说不出自己那一段的，记为危险信号。通用的追问方法见 project-deep-dive。 - 简历出现 MySQL 调优 / 慢 SQL → 追执行计划怎么读、索引怎么改、改后前后数字、有没有因为统计信息或参数误判 - 简历出现主从 / 高可用 / 数据迁移 → 追复制延迟怎么处理、切换过没有、脑裂怎么防、迁移的双写与校验方案 - 简历出现分库分表 → 追分片键、跨片查询、扩过容没有、为什么不先做归档或读写分离 - 简历出现死锁 / 锁等待 → 追死锁日志怎么读、锁加在哪个索引上、业务怎么改 - 简历出现连接池 / 访问层 → 追池大小依据、实例数乘积、超时与重试 - 简历出现 Redis / MongoDB / ES → 追为什么选它、数据模型、一致性怎么保、出过什么事故 ## 常见失守与危险信号 - 存储结构与索引：只知道"B+ 树"三个字；说不出回表与覆盖索引；主键用 UUID 却不知道页分裂 - 事务、隔离级别与 MVCC：把 RR 与 RC 混为一谈；说不出 ReadView 与 undo 版本链；长事务把 undo 撑爆不知道怎么查 - 锁与死锁：不知道锁加在索引上；读不了死锁日志；只会"重试" - SQL 优化与执行计划：只会"加索引"；不看执行计划；深分页用 offset 到几百万 - 主从复制与高可用：不知道复制延迟从哪来；切换靠人肉；不知道半同步的退化 - 数据库扩展与分库分表：一上来就分库分表；说不出分片键依据；不知道跨片事务与分页的代价 - 连接池与访问层：池大小随便填；不知道连接数是实例数的乘积；ORM 生成了什么 SQL 不看 - LSM、KV 与 NoSQL 选型：什么都放 MySQL 或什么都放 MongoDB；不知道 LSM 的写放大与读放大；Redis 大 key 与热 key 没处理过 ## 常考主题清单 只列名字、阶梯与答实的标志，作"问到哪一层算实"的参考；问哪些、问几道由这份 JD 与这份简历定，不是配额。 ### 数据库扩展与分库分表 …
Read the whole file at its exact version.
How to install
mdr add yuecao365/offercome/mysql-internals@git:20260920.a4843f5mdr add yuecao365/offercome/mysql-internals@sha256:2f796490157bc19aPin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.
[](https://markdownregistry.com/a/art_ttsxtp7yknrfjpha)
1 badge views in 30 days
Versions
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (7769 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
yuecao365/offercome · 23 stars · license MIT · pushed 2026-09-23 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_ttsxtp7yknrfjpha GET https://markdownregistry.com/api/v1/resolve?ref=yuecao365/offercome/mysql-internals GET https://markdownregistry.com/api/v1/blob/2f796490157bc19af5e0bdcbf6577659ae1bb523f2a027dcf327f0a29cd11c52
Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.