Database Performance Tuning

日期：2026-06-17 · 场景：Database Performance Tuning

📖 Vocabulary

Word	Meaning	Example
stash	暂存（git 临时保存未提交改动）	Stash your changes before pulling the latest code. 拉取最新代码前先暂存你的改动。
bottleneck	瓶颈（限制整体性能的环节）	The database query became our main bottleneck. 数据库查询成了我们的主要瓶颈。
migration	迁移（数据库结构变更）	Run the migration during the maintenance window. 在维护窗口期间运行迁移。
query	查询（向数据库请求数据）	The search query returns results in under 50ms. 搜索查询在 50ms 内返回结果。
optimize	优化（提升性能或效率）	We need to optimize the slow endpoint before launch. 发布前我们需要优化这个慢接口。

🎧 Audio

💬 Dialogue

A: The dashboard query is taking twelve seconds to load. A：仪表盘查询要 12 秒才能加载完。

B: That is our bottleneck right now. The index is missing on the join. B：那是我们现在的瓶颈。join 上缺索引。

A: Should I run the migration during off-peak hours? A：我该在低峰期跑迁移吗？

B: Yes, and stash your current branch first so the deploy is clean. B：对，先暂存当前分支，让部署干净点。

A: Got it. After we optimize the index, will the cache need warming? A：明白。优化索引后，缓存需要预热吗？

B: Exactly. Run the query once after deploy to populate it. B：没错。部署后跑一次查询把它填上。