Database Profiler数据库档案器

Global and Per-Database Profiling Settings全局和每个数据库的分析设置

The slowms and sampleRate profiling settings are global. slowms和sampleRate分析设置是全局设置。When set, these settings affect all databases in your process.设置后，这些设置将影响进程中的所有数据库。

When set via the profile command or db.setProfilingLevel() shell helper method, profiling level and filter settings are set at the database level. 当通过profile命令或db.setProfilingLevel()shell助手方法进行设置时，将在数据库级别设置概要文件级别和筛选器设置。When set as either command line or configuration file options, profiling level and filter settings affect the entire process.当设置为命令行或配置文件选项时，分析级别和filter设置会影响整个过程。

Specify the Threshold for Slow Operations指定慢速操作的阈值

By default, the slow operation threshold is 100 milliseconds. To change the slow operation threshold, specify the desired threshold value in one of the following ways:默认情况下，慢速操作阈值为100毫秒。要更改慢速操作阈值，请通过以下方式之一指定所需的阈值：

• Set the value of slowms using the profile command or db.setProfilingLevel() shell helper method.使用profile命令或db.setProfilingLevel()shell助手方法设置slowms的值。
• Set the value of --slowms from the command line at startup.在启动时从命令行设置--slowms的值。
• Set the value of slowOpThresholdMs in a configuration file.在配置文件中设置slowOpThresholdMs的值。

For example, the following code sets the profiling level for the current mongod instance to 1 and sets the slow operation threshold for the mongod instance to 20 milliseconds:例如，以下代码将当前mongod实例的评测级别设置为1，并将mongod示例的慢操作阈值设置为20毫秒：

db.setProfilingLevel(1, { slowms: 20 })

Profiling level of 1 will profile operations slower than the threshold.分析级别为1将分析低于阈值的操作。

Starting in MongoDB 4.0, you can use db.setProfilingLevel() to configure slowms and sampleRate for mongos. 从MongoDB 4.0开始，您可以使用db.setProfilingLevel()为mongos配置slowms和sampleRate。For the mongos, the slowms and sampleRate configuration settings only affect the diagnostic log and not the profiler since profiling is not available on mongos. 对于mongos，slowms和sampleRate配置设置只影响诊断日志，而不影响探查器，因为在mongos上无法进行评测。[1]

For example, the following sets a mongos instance's slow operation threshold for logging slow operations:例如，以下设置mongos实例的慢速操作阈值，用于记录慢速操作：

db.setProfilingLevel(0, { slowms: 20 })

Starting in MongoDB 4.2, the profiler entries and the diagnostic log messages (i.e. mongod/mongos log messages) for read/write operations include:从MongoDB 4.2开始，探查器条目和用于读/写操作的诊断日志消息（即mongod/mongos日志消息）包括：

• queryHash to help identify slow queries with the same query shape.以帮助识别具有相同查询形状的慢速查询。
• planCacheKey to provide more insight into the query plan cache for slow queries.以便为慢速查询提供对查询计划缓存的更多了解。

Starting in version 4.2, secondary members of a replica set now log oplog entries that take longer than the slow operation threshold to apply. 从4.2版开始，副本集的辅助成员现在会记录应用时间超过慢速操作阈值的oplog条目。These slow oplog messages:这些慢速操作日志消息：

• Are logged for the secondaries in the diagnostic log.在诊断日志中为辅助设备记录。
• Are logged under the REPL component with the text applied op: <oplog entry> took <num>ms.在REPL组件下记录，并应用文本applied op: <oplog entry> took <num>ms。
• Do not depend on the log levels (either at the system or component level)不依赖于日志级别（在系统或组件级别）
• Do not depend on the profiling level.不要依赖于分析级别。
• May be affected by slowOpSampleRate, depending on your MongoDB version:可能会受到slowOpSampleRate的影响，具体取决于您的MongoDB版本：
  • In MongoDB 4.2, these slow oplog entries are not affected by the slowOpSampleRate. MongoDB logs all slow oplog entries regardless of the sample rate.在MongoDB 4.2中，这些慢速操作日志条目不受slowOpSampleRate的影响。MongoDB记录所有慢速操作日志条目，而不管采样率如何。
  • In MongoDB 4.4 and later, these slow oplog entries are affected by the slowOpSampleRate.在MongoDB 4.4及更高版本中，这些慢速操作日志条目受到slowOpSampleRate的影响。

The profiler does not capture slow oplog entries.探查器未捕获慢速操作日志项。

Profile a Random Sample of Slow Operations评测慢速操作的随机样本

To profile only a randomly sampled subset of all slow operations , specify the desired sample rate in one of the following ways: 要仅评测所有慢速操作的随机采样子集，请通过以下方式之一指定所需的采样率：[2]

• Set the value of sampleRate using the profile command or db.setProfilingLevel() shell helper method.使用profile命令或db.setProfilingLevel()shell助手方法设置sampleRate的值。
• Set the value of --slowOpSampleRate for mongod or --slowOpSampleRate for mongos from the command line at startup.在启动时，从命令行为mongod设置--slowOpSampleRate的值，或为mongos设置--slowOpSampleRate的值。
• Set the value of slowOpSampleRate in a configuration file.在配置文件中设置slowOpSampleRate的值。

By default, sampleRate is set to 1.0, meaning all slow operations are profiled. 默认情况下，sampleRate设置为1.0，这意味着将分析所有慢速操作。When sampleRate is set between 0 and 1, databases with profiling level 1 will only profile a randomly sampled percentage of slow operations according to sampleRate.当sampleRate设置在0和1之间时，分析级别为1的数据库将仅根据sampleRate对慢速操作的随机采样百分比进行分析。

For example, the following method sets the profiling level for the mongod to 1 and sets the profiler to sample 42% of all slow operations:例如，以下方法将mongod的评测级别设置为1，并将评测器设置为对所有慢速操作的42%进行采样：

db.setProfilingLevel(1, { sampleRate: 0.42 })

The modified sample rate value also applies to the system log.修改后的采样率值也适用于系统日志。

Starting in MongoDB 4.0, you can use db.setProfilingLevel() to configure slowms and sampleRate for mongos. 从MongoDB 4.0开始，您可以使用db.setProfilingLevel()为mongos配置slowms和sampleRate。For the mongos, the slowms and sampleRate configuration settings only affect the diagnostic log and not the profiler since profiling is not available on mongos. 对于mongos，slowms和sampleRate配置设置只影响诊断日志，而不影响探查器，因为在mongos上无法进行评测。[1]

For example, the following sets a mongos instance's sampling rate for logging slow operations:例如，以下设置mongos实例的采样率，用于记录慢速操作：

db.setProfilingLevel(0, { sampleRate: 0.42 })

Set a Filter to Determine Profiled Operations设置筛选器以确定分析的操作

You can set a filter to control which operations are profiled and logged. 您可以设置一个筛选器来控制对哪些操作进行分析和记录。You can set the profiling filter in one of the following ways:您可以通过以下方式之一设置分析筛选器：

• Set the value of filter using the profile command or db.setProfilingLevel() shell helper method.使用profile命令或db.setProfilingLevel()shell助手方法设置filter的值。
• Set the value of filter in a configuration file.在配置文件中设置filter的值。

For mongod instances, the filter affects both the diagnostic log and, if enabled, the profiler.对于mongod实例，filter会影响诊断日志，如果启用，还会影响探查器。

For mongos instances, the filter affects the diagnostic log only and not the profiler since profiling is not available on mongos.对于mongos实例，filter只影响诊断日志，而不影响探查器，因为在mongos上无法进行探查。

For example, the following db.setProfilingLevel() method sets for a mongod instance:例如，以下db.setProfilingLevel()方法为mongod实例设置：

• the profiling level to 2,探查器级别为2，
• the filter of { op: "query", millis: { $gt: 2000 } }, which causes the profiler to only log query operations that took longer than 2 seconds.{ op: "query", millis: { $gt: 2000 } }的筛选器，这将导致探查器只记录耗时超过2秒的query操作。

db.setProfilingLevel( 2, { filter: { op: "query", millis: { $gt: 2000 } } } )

Check Profiling Level检查分析级别

To view the profiling level, issue the following from mongosh:要查看评测级别，请从mongosh发布以下内容：

db.getProfilingStatus()

The shell returns a document similar to the following:shell返回一个类似于以下内容的文档：

{ "was" : 0, "slowms" : 100, "sampleRate" : 1.0, "ok" : 1 }

The was field indicates the current profiling level.was字段表示当前的分析级别。

The slowms field indicates operation time threshold, in milliseconds, beyond which operations are considered slow.slowms字段指示操作时间阈值（以毫秒为单位），超过该阈值的操作将被视为慢速。

The sampleRate field indicates the percentage of slow operations that should be profiled.sampleRate字段指示应分析的慢速操作的百分比。

Disable Profiling禁用分析

To disable profiling, use the following helper in mongosh:要禁用分析，请在mongosh中使用以下帮助程序：

db.setProfilingLevel(0)

Enable Profiling for an Entire mongod Instance为整个mongod实例启用分析

For development purposes in testing environments, you can enable database profiling for an entire mongod instance. 为了在测试环境中进行开发，可以为整个mongod实例启用数据库评测。The profiling level applies to all databases provided by the mongod instance.评测级别适用于mongod实例提供的所有数据库。

To enable profiling for a mongod instance, pass the following options to mongod at startup.要启用mongod实例的评测，请在启动时将以下选项传递给mongod。

mongod --profile 1 --slowms 15 --slowOpSampleRate 0.5

Alternatively, you can specify operationProfiling in the configuration file.或者，您可以在配置文件中指定operationProfileing。

This sets the profiling level to 1, defines slow operations as those that last longer than 15 milliseconds, and specifies that only 50% of slow operations should be profiled. 这将分析级别设置为1，将慢速操作定义为持续时间超过15毫秒的操作，并指定只应分析50%的慢速操作。[2]

The slowms and slowOpSampleRate also affect which operations are recorded to the diagnostic log when logLevel is set to 0. 当logLevel设置为0时，slowms和slowOpSampleRate还会影响将哪些操作记录到诊断日志中。The slowms and slowOpSampleRate are also available to configure diagnostic logging for mongos. slowms和slowOpSampleRate也可用于配置mongos的诊断日志记录。[2]

Database Profiling and Sharding数据库分析和共享

You cannot enable profiling on a mongos instance. 您不能在mongos实例上启用分析。To enable profiling in a sharded cluster, you must enable profiling for each mongod instance in the cluster.要在分片集群中启用评测，必须为集群中的每个mongod实例启用评测。

However, starting in MongoDB 4.0, you can set the --slowms and slowOpSampleRate on mongos to configure the diagnostic log for slow operations.但是，从MongoDB 4.0开始，您可以在mongos上设置--slowms和slowOpSampleRate来配置慢速操作的诊断日志。

Example Profiler Data QueriesProfiler数据查询示例

This section displays example queries to the system.profile collection. For an explanation of the query output, see Database Profiler Output.本节显示对system.profile集合的示例查询。有关查询输出的说明，请参阅数据库档案器输出。

To return the most recent 10 log entries in the system.profile collection, run a query similar to the following:要返回system.profile集合中最近的10个日志条目，请运行类似于以下内容的查询：

db.system.profile.find().limit(10).sort( { ts : -1 } ).pretty()

To return all operations except command operations ($cmd), run a query similar to the following:要返回除命令操作（$cmd）之外的所有操作，请运行类似于以下内容的查询：

db.system.profile.find( { op: { $ne : 'command' } } ).pretty()

To return operations for a particular collection, run a query similar to the following. 若要返回特定集合的操作，请运行类似于以下内容的查询。This example returns operations in the mydb database's test collection:此示例返回mydb数据库的test集合中的操作：

db.system.profile.find( { ns : 'mydb.test' } ).pretty()

To return operations slower than 5 milliseconds, run a query similar to the following:要返回低于5毫秒的操作，请运行类似于以下内容的查询：

db.system.profile.find( { millis : { $gt : 5 } } ).pretty()

To return information from a certain time range, run a query similar to the following:要返回特定时间范围内的信息，请运行类似于以下内容的查询：

db.system.profile.find({
  ts : {
    $gt: new ISODate("2012-12-09T03:00:00Z"),
    $lt: new ISODate("2012-12-09T03:40:00Z")
  }
}).pretty()

The following example looks at the time range, suppresses the user field from the output to make it easier to read, and sorts the results by how long each operation took to run:以下示例查看时间范围，从输出中取消user字段以便于阅读，并根据每个操作运行的时间对结果进行排序：

db.system.profile.find({
  ts : {
    $gt: new ISODate("2011-07-12T03:00:00Z"),
    $lt: new ISODate("2011-07-12T03:40:00Z")
  }
}, { user: 0 }).sort( { millis: -1 } )

Show the Five Most Recent Events显示最近发生的五件事

On a database that has profiling enabled, the show profile helper in mongosh displays the 5 most recent operations that took at least 1 millisecond to execute. 在启用了概要分析的数据库上，mongosh中的show profile helper显示执行至少需要1毫秒的5个最新操作。Issue show profile from mongosh, as follows:从mongosh发出show profile，如下所示：

show profile

The system.profile Collectionsystem.profile集合

The system.profile collection is a capped collection with a default size of 1 megabyte. system.profilee集合是一个封顶集合，默认大小为1兆字节。A collection of this size can typically store several thousand profile documents, but some applications may use more or less profiling data per operation. 这种大小的集合通常可以存储数千个配置文件文档，但有些应用程序可能会在每次操作中使用或多或少的配置文件数据。If you need to change the size of the system.profile collection, follow the steps below.如果需要更改system.profile集合的大小，请按照以下步骤操作。

Change Size of system.profile Collection on the Primary更改Primary上system.profile集合的大小

To change the size of the system.profile collection on the primary, you must:要更改primary上system.profile集合的大小，必须：

1. Disable profiling.禁用分析。
2. Drop the system.profile collection.删除system.profile集合。
3. Create a new system.profile collection.创建新的system.profile集合。
4. Re-enable profiling.重新启用分析。

For example, to create a new system.profile collection that is 4000000 bytes (4 MB), use the following sequence of operations in mongosh:例如，要创建一个4000000字节（4 MB）的新system.profile集合，请在mongosh中使用以下操作序列：

db.setProfilingLevel(0)

db.system.profile.drop()

db.createCollection( "system.profile", { capped: true, size:4000000 } )

db.setProfilingLevel(1)

Change Size of system.profile Collection on a Secondary更改Secondary上system.profile集合的大小

To change the size of the system.profile collection on a secondary, you must stop the secondary, run it as a standalone, and then perform the steps above. 要更改secondary上的system.profile集合的大小，必须停止辅助系统，将其作为独立系统运行，然后执行上述步骤。When done, restart the standalone as a member of the replica set. 完成后，作为复制副本集的成员重新启动单机版。For more information, see Perform Maintenance on Replica Set Members.有关详细信息，请参阅对副本集成员执行维护。