补充上一章
楼主还遇到好几次一个月经八股题:“What happens after you enter a URL on the browser?”
在 HR 或 HM 面试中被问到, 如果事先没复习挺难答全。当然,一般问这个问题的也不是什么特别好的公司,哈哈。
. .и
这章聊System Design
使用 AI 辅助准备.
现在比较幸福的一点AI 确实能帮不少忙。
楼主主要用 ChatGPT、Claude 和 Grok。最后的感觉是:
ChatGPT:回答速度快,结构清晰,适合快速学习和验证思路;
Grok:回答质量非常高,尤其在细节部分;
Claude:反而有点尴尬,用得越来越少。
我每天会让 AI 出几道新题,然后在看答案之前自己思考一下。
Prompts,
This is done before, please come up a new system design question and answer it in flow of:
1. functional requirements. 1point 3 acres
2. non-functional requirements
3. core entities
4. simple API endpoints. Χ
5. high level ASCII diagram (critical workflow explain)
6. deep dive of non-functional requirements
知识点
✅ 1. 数据库与存储系统
数据模型与性能优化
.google и
- Query Optimization / Denormalization / Partition / Sharding
- N+1 Query
- primary index vs secondary index vs global index
并发与一致性
- How to prevent race Condition
- How to prevent transaction overwrite (locking / lock-free approaches)
- ACID / row lock / distributed lock
. From 1point 3acres bbs
数据库类型对比
. 1point 3acres
- MySQL vs NoSQL vs TimeSeries DB
. 1point 3 acres
分布式一致性机制
- Consistent Hashing
存储系统概念
- OLAP vs OLTP
- ElasticSearch-baidu 1point3acres
- ELK
✅ 2. 后端架构与性能
性能优化
- Speed up on Read Path
- Speed up on Write Path
缓存策略
- Caching Strategies
- Cache Warm-Up
热点与广播
- Sharing: Push vs Pull
- Fanout vs Hotspot(名人效应)
高可用设计
- Usage Too High issues (connection count, CPU, memory, disk, storage, cache)
- CP vs AP
-baidu 1point3acres
Pagination
- Pagination(Cursor vs Offset)
.
✅ 3. 系统交互与 API 通信. check 1point3acres for more.
API 设计
- RESTful API vs GraphQL API vs gRPC. Χ
- API Gateway
与第三方通信
- Talk to 3rd Party API(Backoff, Retry, Timeout, Circuit Breaker, Random Select, Local Fallback)