MongoDB慢查询

最新推荐文章于 2025-09-10 20:20:06 发布

weixin_30882895

最新推荐文章于 2025-09-10 20:20:06 发布

阅读量87

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/hyming011/p/8251752.html

本文介绍了MongoDB的性能分析工具——Profiler的使用方法。通过设置不同的级别可以记录所有操作或仅记录慢查询，帮助开发者识别低效的查询和操作。文章详细解释了如何设置Profiler并查询超过指定时间的操作。

##### 参考 https://docs.mongodb.com/v3.2/administration/analyzing-mongodb-performance/
##### 参考 https://docs.mongodb.com/v3.2/reference/method/db.setProfilingLevel/#db.setProfilingLevel
Database Profiling

MongoDB’s “Profiler” is a database profiling system that can help identify inefficient queries and operations.

Level Setting
0 Off. No profiling
1 On. Only includes “slow” operations
2 On. Includes all operations

Parameter Type Description
level integer Specifies a profiling level, which is either 0 for no profiling, 1 for only slow operations, or 2 for all operations.
slowms integer Optional. Sets the threshold in milliseconds for the profile to consider a query or operation to be slow.

######
db.setProfilingLevel(level, slowms)

db.setProfilingLevel(1) 设置时slowms = 100ms 记录所有大于100ms的记录

db.system.profile.find( { millis : { $gt : 100 } } ) #### 查询大于100ms的记录

转载于:https://www.cnblogs.com/hyming011/p/8251752.html