数据库与存储
mysql-innodb-refactor
更新于 2026-09-10
MySQL · 重构规则
Refactoring rules for MySQL: characterisation tests, behaviour-free diffs and seam-by-seam extraction.
- 技术栈
- MySQL
- 主题
- 重构
- 条目
- 9 条
- 版本
- v0.2.0
✓ 应当这么做
- ✓ Characterise current behaviour with tests before touching structure
- ✓ Keep refactor commits free of behaviour change and vice versa
- ✓ Extract one seam at a time and delete the old path in the same change
✕ 常见反模式
- ✕ Rewriting and changing features in one unreviewable diff
- ✕ Leaving both old and new implementations alive indefinitely
- ✕ Refactoring code no requirement currently touches
◎ 交付前验证
- ◎ EXPLAIN on the hot queries shows no sequential scan regression
- ◎ Migration rehearsed on a production-size snapshot
- ◎ Rollback path executed at least once in staging
同分类条目
26 篇数据库与存储
PostgreSQL 工程规则
Zero-downtime PostgreSQL rules: expand/contract phases and concurrent index builds
数据库与存储
MySQL 工程规则
MySQL rules: online DDL awareness, lock timeouts and reversible migrations
数据库与存储
Redis 工程规则
Redis rules: explicit TTLs, versioned keys and stampede-safe misses
数据库与存储
MongoDB 工程规则
MongoDB rules: explicit schema validators and index-backed query shapes
数据库与存储
ClickHouse 工程规则
ClickHouse rules: partition pruning, column ordering and batch inserts
数据库与存储
Elasticsearch 工程规则
Elasticsearch rules: alias-based reindexing and mapping compatibility