数据库性能分析与优化（爱测未来团队内训材料）

爱被打了一巴掌 2024-04-18 08:29 59阅读 0赞

![format_png][]

![format_png 1][]

![format_png 2][]

![format_png 3][]

![format_png 4][]

![format_png 5][]

![format_png 6][]

![format_png 7][]

![format_png 8][]内存管理方式：MSMM、ASMM(sga\_target)、AMM(memory\_target) 小内存有小内存的问题，大内存有大内存的麻烦！ORA-04031 Buffer cache 和 sharedpool size 的 begin/end值在 ASMM、AMM 和 11gR2MSMM 下可是会动

![format_png 9][]

Parses 解析次数，包括软解析+硬解析，我们希望的是 解析一次 到处运行！HardParses 万恶之源．Cursorpin s on X， librarycache: mutex X ， latch: row cache objects /sharedpool……………..。硬解析最好少于每秒 20 次

![format_png 10][]

![format_png 11][]

log file sync：一般此类等待时间是由于 LGWR 进程讲 redo log buffer 写入 redo log 中发生。

commit次数是否过多

![format_png 12][]

![format_png 13][]

有的组件对响应时间要求比较高，测试过程中我们应将慢查询阈值，设置尽量小。

有的SQL可能是做一些统计用的，没有实时性的要求，这时在测试时，慢查询阈值可以设置高一点。

![format_png 14][]

![format_png 15][]

![format_png 16][]

![format_png 17][]

Statspack-生成快照

![format_png 18][]

![format_png 19][]

![format_png 20][]

![format_png 21][]

建议:计算一下使用率：10% < 连接数使用率 < 85% .

![format_png 22][]

![format_png 23][]

![format_png 24][]

![format_png 25][]

10046 trace来跟踪Oracle

![format_png 26][]

![format_png 27][]

![format_png 28][]

![format_png 29][]

![format_png 30][]

![format_png 31][]

![format_png 32][]

![format_png 33][]

![format_png 34][]

![format_png 35][]

![format_png 36][]

![format_png 37][]

![format_png 38][]

1、索引是用来提高查询SQL性能的，但有些情况下的查询是无法使用索引的，建了也没用

2、接下来我们看下我们常用的查询类型有哪些。

3、不同类型的查询，建立索引时我们需要注意些什么

![format_png 39][]

![format_png 40][]

1、不同的存储引擎支持的索引方法不同

2、这里以InnoDB引擎，支持的Btree索引为例说明

![format_png 41][]

![format_png 42][]

这里不我们不光查询条件firstname要加索引，排序的字段也需要加入索引

![format_png 43][]

1、对查询结果使用group by进行分组时，需要加索引。

2、使用distinct进行唯一性查询时，firstname字段虽然不是作为查询条件，需要加入索引。

![format_png 44][]

![format_png 45][]

左连接：以左表为基准（左表取的是全部数据），到右表按条件匹配数据。搜索条件都在右表启作用，所以索引建立在右表。

![format_png 46][]

（喜欢请转发，谢谢！）

加入爱测未来qq群，获取更专业的技术知识分享：

274166295  （爱测未来二群）

610934609  （爱测未来三群）

195730410  （爱测未来四群）

更多精彩文章：

[移动端H5调试与自动化][H5]

[Android兼容性测试应该怎么做逼格更高呢？][Android]

[JVM性能调优][JVM]

[MTP-移动测试平台][MTP-]

[性能分析之OS资源饱和度][OS]

[前端性能监控][Link 1]

[来自520的福利----视频直播平台性能测试][520_----]

[前端性能测试平台及应用][Link 2]

[震惊性能测试圈的经典案例！！][Link 3]

——————————————————

爱测未来公众号

WX:itest\_forever

![format_png 47][]

测试之道 | 测试技术

长按识别二维码，关注爱测未来公众号，了解更多精彩内容

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3VaSFFQNndDalZDY3c0U2xyVk1YYXJoVEhnZjBRcTJiaWFzY0o2TTV6VUxzdzlKdlJDNGY2aHcvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2R1bHFDYzhSV29Qd1NYZ1NobXllZVFYWDhETnpIclQzblRqNHZLMEp2QW1DdTFQV0VGM0N4dy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3dzl3djJjSkZ6aWJOUGx1NmpUaWJxNEdLcENvS1l4dHg2cldCbTVpYkx1amNIaWJRWlExWkdlS0diN0EvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d0hsOWNNS1NzY1FMeHpSNG56WUNoaWN2aWNrbWdXQmRid2VFT1g4QzBaZFBGNWtGZU5ZczNOMVBBLzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2ljdUJCcTdnZXdXeG9sRnZtMk9nbUNNWXU2eVZwTGh5cGZmSXZhNmlicGZLaWNCWmljRmx1U2toMXcvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3dzUxNHNIbFhJVUJ6SWlhUU5IbVpjSmU3WVZ6Z2hpYmo0eGxWbmFOcGliVDNFWHBhU2RvMVB6M1Zvdy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1pucmJnSjVPaWJRM0dFSU1PRGFwc1lIR3RSUWRQQ0w2N1o5eFF4TEoyY0o3dEhybFlPNzd0M0EvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1pteVAwdVlwSlU2YllCcWd2M2NGZDJuTmNuS3hZSGJNMFg3cndacExPd2ljSGR5TURWMTA0dkEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3FZNWE1cXl4MUlNblF2eTlUalA2amlhVFlsQnloRnY5Z0NkMEhyQnVUT0J5U1NZTmQ0dlhpYU93LzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3dzl2aWN2SkVZWkE5d0FGRVl0aWJBZDBiZXVKTk9waFpNZmNBQWVVOWpkN1NYSzBLUU4zd1BOcUd3LzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3B3NThuMEQ3WkV1TXVjSmhqUzJvanJzWG1xbVZld3NEUjh4VGFVVmV4bmx5bDZpYlpUNFJGbEEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 11]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1h4WHVBOUw3NjNXbmliR0FYMU12cGhTVk9wQzR3QURjcnpQNmFnRW8ydlU3ZllxOUV0VTJQWUEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 12]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3o4cXROVWI5b1hFaWJrcnU1aWMySzRGSWtkcG9wUnp3RUVhWkNUZjA5OW5QMTVkWjREM1RpYVZpYlEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 13]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2RxWEI4YzZQQ3FiUG1CMjUyVklqNnhHYjZFYjkxUzh4aktld3JBS2p2M1NqR25XS0VnaWFlYkEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 14]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d0dpY0NIVEVuNHBjaWN3a0dJS0xKZ0s1bjZUMHB2Q2hJZDg5eFdXR2RldWExRVdSbzE5REZ2RGlhQS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 15]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2F6ZVRtRnRoMlZGUWdzNnc1aWNTY1R5SjRYbVlJaWExNzNtV0ZvNUNpYWVwNlozQmlhT29LdFRaaWFBLzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 16]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3VNbVRYRDJrRVdZUW10SENFdGRQZFZ1QWJaWmRyTnJ5TzJyOUFiNFZSSGRLcjBVd09uU29DZy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 17]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3JnQUUxMnA5c0s0UVVJdUdnTGZtUjFudXE3NUZaVGRQZEo1SUw3YVhQUlRSelc0TkhTa2xIdy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 18]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2VkQnlFeHFQVDdoUzVpYk5pY29IbFZ4RlZ2dmhCVjN3Y3k2cWp1THhzOWxxZnNvVlFEWlFpY2lhbmcvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 19]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d04zbVA0NFJFejZydHZhbGZlQ2xCb0x0czA1eFltaWJndllBS01kWDI2emNCSDBtaGVpYUhMNG53LzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 20]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3BWTnM0bERYRjVSa1MxREpGMmlhTHNpYVRuT0I1aFl1ekxxaWM3RW9uRjljZFlERzFtUFp2U2hVZy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 21]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1hraFh6Q1VEaWM3ZExjSmVuN3F4OGliaWN1Z2liM2pXRGFyc0swSnhjaWNoZ3hOeXBRcjlnRzlsR1R3LzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 22]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3dzRpYTZIRkxPRTZMRXczQ0JaYnRhQmV3V0pUU0VpY3lGck9MRUFYVFMzN1dTZDBDTW1zMThXbmpnLzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 23]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1J3d2hpYXpaYWNQZm56cnJiYWZlN0pDSjM2elBMRXVPaWNOME1yMlhsbEh1bUpLZE1GOWlhZDdUUS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 24]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2VlcndjamdPY1dNQ2dBTHY0S2NPZWwwa0JSMzdPWmF3S2NDUm1GVHhKMUZHRW96WWpJcjN1Zy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 25]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2djQXNpYzZnUGNVekZjS3Bwc3REaWNWWGx1cFdnUTJ1ZVJtSXdSS1hIcVVOeUpUT3d6cWFNaWFCUS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 26]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d05SclExVFg0WG0xQlVlaG5rQkZiTTRub1p2b3Q5aGhpYjVtdVFrRU9NZkIxOThvZk9QN296RGcvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 27]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1RnRWlhYWljUDdpYTNGQTFxWTgwNGtOMkhoTktLaWE1RndBd3hheHRyYTR2SXIxVlFjWEljbFhOdlEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 28]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2ljdzJMUHFpYUdqTDJLeGZxN0tKQmlheDR5Z05tS0Y3dGtsSlBhUlhVSHIweWljbHhpYURIb25qcHVRLzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 29]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3dzVEU1RpYjk2M08wSnFjNFZDZm5YUk1hYmlieGpnaWFmVG1uQkUxQnVNRlV1bjN6eXZpY0JROFk4R1EvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 30]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1J3S242cWU2YlFjak9udE90SkswMG5PUXEwUzJCMHBVMTZaa0hSMk5wZVJEdTgzTEZJM1BoUS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 31]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d21PNkRzT2VLY2lidTRZOVJVYUJtTU9VVDBrNDJoSVcxaGYwVHgwUDByZFVFNkhPVnRZZVJHZFEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 32]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d0hhcVE4Qmt5cUNZUFI3Sm56TXh2U2ZyOExXbEZwSEcxU0poZlBxSzdUWTBCc2liNTJtZHRyMUEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 33]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1A0R1hTOHZGNm5vTkhUTXI3YXlobk1qTlNDd3owS0kyS2NENHhKa1pkVTZUWXB1WHdyQThMdy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 34]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3lSdDdLT1E2OFZFRlJtV1NjaktpYUF6dmRpYUM2eklyUTNseG9VUUkzME5qOGRjbVk2cUpXcnZ3LzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 35]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1diSnUwUUNMWnRaaWFCaHBETHppY01qd0NveFlvWDdaV1gybllVQ0RvazdjMXZsOXBpYWtUaWFUeXcvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 36]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2ZXZzltUFhCVUtlSHlRU0dsak9GT1BRNnVCbTdIR2F4ak1jWFU0WUFrTjlRNk4zZXFhaWF2RWcvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 37]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1NmSjJTelVDandQMDVWSUw5QlU0MFRTYlNvTW5uTFNENk50Zk9KSVg2dUZmYnZ1RXNUcDFtUS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 38]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d25RTnJXUjZTa0ZTaWNiMmljQmw2NWljVjR2ak41QW5OSkYyUzJ3QmdMOXIwTHNtMGVJcThMQ1VkQS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 39]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2liU21nNWFRV0wzRVhzbHdNZGZSOW1lWFJ0RDB3aWNSbEhpYTFSRHBFVzIweHJaWEU5b3dJOTRSQS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 40]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d0w0ZmpIaWJXNmhXc3ZUSmJYbjZvdmZDdzN4S3VNYU9BSWduVVFzVGlhRVozYldXenVqaWJBZUNQQS82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 41]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3dzZJbkJGT29FRFMxUFd4VGdBOXc3aWExU1VSU29yb0ZHa2RQU3VXenkxOXhKeDhFZ3NwbHNRNlEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 42]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3dzZoandiMGlhYjNkUVJMc0FCQWNLdmo4S3NBRU5kbmR1dFBoTndpYWljTkRPRXN6cW9SN1VodENoZy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[format_png 43]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2JzQmVqV1VidzB0OVVqcjJaVGtZdFFqRVk4NzYydVZNaG5CbUF2YVZ4Q0FxRHd1MkVGaWM4Q2cvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 44]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d3NnUklEamlhcERXY0pyVzR1R2lhWm9GcUdEUWliRnpSV3lLVFZZaWFFekM2SlFhREk4R3ptQ1ppYW13LzY0MD93eF9mbXQ9cG5n?x-oss-process=image/format,png
[format_png 45]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d2haSVVPUmJwSHJLMWZlWW1rcGczZlluM0lab01SU3BaODRNaWJKYTk3WDFGTXczbTBhQWViRlEvNjQwP3d4X2ZtdD1wbmc?x-oss-process=image/format,png
[format_png 46]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBSThrSU9BSll2OUJZNElGdFI5dnB3d1VkNkdTOEpZTFdqNFpRcjBoa053MEdyclUyVklwMWNMQnNEMUczQjRKVkZzdWZsb0NtZ0Z0dy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png
[H5]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247483979&idx=1&sn=7dfe9b5272e8e4114a044c7004217554&chksm=e8e57d53df92f445386a07a3f9857c5387afe46b32099e964048e3153b71c0dbef94f6021519&scene=21#wechat_redirect
[Android]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247485367&idx=1&sn=47d25a996707eea2068414d91f92d9b9&chksm=e8e578afdf92f1b9746d583b2a9fe164983be4ec531eab97f610bb55412f55af9029fbc67a06&scene=21#wechat_redirect
[JVM]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247485348&idx=1&sn=4fe30e15f668db9c457188c6de75b999&chksm=e8e578bcdf92f1aa714f52eff622fb6ba4e87c7dc8351f722a397e8c4e54c7ca4303900a7d73&scene=21#wechat_redirect
[MTP-]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247485194&idx=1&sn=448d170ee990a75e88bedb269476519e&chksm=e8e57812df92f1049d871284489732396157d183364e45f868c71527a91f5f34138922f015bc&scene=21#wechat_redirect
[OS]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247485367&idx=2&sn=7a850720ec5d1c86e2c2296ff17e00e9&chksm=e8e578afdf92f1b94d7d8896c7d74fff4694407f4ecf9234388c1633f0904b19505bee921b35&scene=21#wechat_redirect
[Link 1]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247484484&idx=1&sn=6d280c97689d9bfd47862f11acb0465b&chksm=e8e57b5cdf92f24ad6c3d1b360ff47bf3e1c64888676838780d11ed7ac636b85259b74a6b67c&scene=21#wechat_redirect
[520_----]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247484887&idx=1&sn=67b21e3248a66544973065f86d1a2f0b&chksm=e8e57acfdf92f3d94b9f363a75fc59a5332671fc616f14e575fc9f643346abafd0498cf60c53&scene=21#wechat_redirect
[Link 2]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247484099&idx=1&sn=87416e2b4d41fe49689e1b4c8c3c8406&chksm=e8e57ddbdf92f4cdc0ada1d3b93b431c7094eb802b43fea8816b42f6b2bf9c706047d6c1a2af&scene=21#wechat_redirect
[Link 3]: http://mp.weixin.qq.com/s?__biz=MzIzNTYyOTE3NQ==&mid=2247484831&idx=1&sn=f0eabefe0857ecf36c0102c93641ecf4&chksm=e8e57a87df92f3913b79e6f85f667fa846c2c910b84a54b3b19ab47b0ceae7e5cf70a68324dd&scene=21#wechat_redirect
[format_png 47]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9Bdll6U0daUUZBTFAyR1VaMzFXbkxsWlNTZDgxZGtUeGFpY29RZUtmMGFNS3dpY05sVEZORmIwbXpwRUVMM1Q1Qm5zWkgxbW5oZ1NYaWNRSHI4MloweG1PZy82NDA_d3hfZm10PXBuZw?x-oss-process=image/format,png