# MongoDB教育訓練-09

查詢緩慢

- 沒有使用index

解決

- 查看database log
- 開啟 profiling

[![image-1639721837613.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/VxB6quNoXw59D2qD-image-1639721837613.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/VxB6quNoXw59D2qD-image-1639721837613.png)

[![image-1639721953030.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/eX8GGpQ2wpDf116l-image-1639721953030.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/eX8GGpQ2wpDf116l-image-1639721953030.png)

[![image-1639722038224.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/ufhJqUKSnXZ7SEHc-image-1639722038224.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/ufhJqUKSnXZ7SEHc-image-1639722038224.png)

level 2 性能會影響

[![image-1639722277872.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/QGO3hYQQM0zAyXZ3-image-1639722277872.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/QGO3hYQQM0zAyXZ3-image-1639722277872.png)

db.setProfilingLevel(1,5) #level 1, 查詢大於5毫秒

[![image-1639722367579.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/QI2cwOiCMNzCUrUw-image-1639722367579.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/QI2cwOiCMNzCUrUw-image-1639722367579.png)

---

### 慢查詢的原因

- 缺少index
- 寫入資料超出disk 性能
- 高CPU使用
- 巢狀join

[![image-1639722562542.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/0lef2dE3IDxIl9Fm-image-1639722562542.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/0lef2dE3IDxIl9Fm-image-1639722562542.png)

---

[![image-1639723682887.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/UC4AiylyoipWvR8X-image-1639723682887.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/UC4AiylyoipWvR8X-image-1639723682887.png)

[![image-1639723703346.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/Qr9kRrZQbcNhThL5-image-1639723703346.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/Qr9kRrZQbcNhThL5-image-1639723703346.png)

[![image-1639723975695.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/H3NOG4rJDGcaqBlb-image-1639723975695.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/H3NOG4rJDGcaqBlb-image-1639723975695.png)

[![image-1639724124142.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/ybJiSLF4TbQmBTzK-image-1639724124142.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/ybJiSLF4TbQmBTzK-image-1639724124142.png)

[![image-1639723989853.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/Yqt1hEruRAL7S0xe-image-1639723989853.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/Yqt1hEruRAL7S0xe-image-1639723989853.png)

[![image-1639724147258.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/ejdOvHO91KXtbi4P-image-1639724147258.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/ejdOvHO91KXtbi4P-image-1639724147258.png)

[![image-1639724475480.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/5zO0nzrtHpYPxbMo-image-1639724475480.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/5zO0nzrtHpYPxbMo-image-1639724475480.png)

[MongoDB Compass Download | MongoDB](https://www.mongodb.com/try/download/compass?tck=docs_compass)

[![image-1639724538158.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/ce4cJzb96maJr7T6-image-1639724538158.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/ce4cJzb96maJr7T6-image-1639724538158.png)

[![image-1639724837767.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/7lGIDr1EPdAigO6W-image-1639724837767.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/7lGIDr1EPdAigO6W-image-1639724837767.png)

[![image-1639725028397.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/XLwTmGbYiHbsTS7i-image-1639725028397.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/XLwTmGbYiHbsTS7i-image-1639725028397.png)

[![image-1639725068655.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/hEnDhowWWilE3kL4-image-1639725068655.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/hEnDhowWWilE3kL4-image-1639725068655.png)

[![image-1639725233859.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/DhOg54QUXLFGGxDZ-image-1639725233859.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/DhOg54QUXLFGGxDZ-image-1639725233859.png)

[![image-1639725262005.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/g1j8D8AgfsVG7tgj-image-1639725262005.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/g1j8D8AgfsVG7tgj-image-1639725262005.png)

[![image-1639725411915.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/vmxyYKJqoxaybrWB-image-1639725411915.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/vmxyYKJqoxaybrWB-image-1639725411915.png)

[![image-1639726437813.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/cxzxIMca9fhL52lF-image-1639726437813.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/cxzxIMca9fhL52lF-image-1639726437813.png)

[![image-1639726650401.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/Jmp44ML3bOBXP0O5-image-1639726650401.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/Jmp44ML3bOBXP0O5-image-1639726650401.png)

[![image-1639726779203.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/1TEZigJ62aqgiaud-image-1639726779203.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/1TEZigJ62aqgiaud-image-1639726779203.png)

[![image-1639727675464.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/H4GJTeQ67U3GZcEW-image-1639727675464.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/H4GJTeQ67U3GZcEW-image-1639727675464.png)

[![image-1639727685022.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/GnGQRtLft0j6ZNNU-image-1639727685022.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/GnGQRtLft0j6ZNNU-image-1639727685022.png)

[![image-1639727814455.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/kdGOflVBf1uVssfs-image-1639727814455.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/kdGOflVBf1uVssfs-image-1639727814455.png)

[![image-1639727848116.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/IJN81R5wMLmxxQ0m-image-1639727848116.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/IJN81R5wMLmxxQ0m-image-1639727848116.png)

[![image-1639729086371.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/ULXwTEx0uINo8kEN-image-1639729086371.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/ULXwTEx0uINo8kEN-image-1639729086371.png)

[![image-1639728235333.png](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/scaled-1680-/QyhN1K9QMu771Exp-image-1639728235333.png)](https://bookstack.treemanou.com/uploads/images/gallery/2021-12/QyhN1K9QMu771Exp-image-1639728235333.png)