[SERVER-75890] Indicate user/system operations and collectionType in currentOp/ slow query Created: 10/Apr/23  Updated: 21/Nov/23  Resolved: 04/Nov/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.2.0-rc0

Type: Improvement Priority: Critical - P2
Reporter: Eric Milkie Assignee: Adi Agrawal
Resolution: Fixed Votes: 0
Labels: query-product-scope-1, query-product-urgency-2, query-product-value-1
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
is related to SERVER-44735 track metrics for system initiated op... Backlog
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-10-16, QE 2023-10-30, QE 2023-11-13
Participants:

 Description   

Certain InTel features like the profiler, the performance advisor, and the real time performance panel consume both the output from $currentOp and slow query logs. It would improve the user experience of these if we could easily filter out internal operations. I think it would be easiest if we simply added a boolean field to each entry in the output of $currentOp and slow query log lines (and the profiler) indicating internal operations.
It used to be the case that user operations could be identified by matching the thread name to "conn####" but this is no longer the case in newer versions of the server.



 Comments   
Comment by Rachelle Palmer [ 21/Nov/23 ]

yes please backport if LOE is not terribly high

Comment by Githook User [ 04/Nov/23 ]

Author:

{'name': 'Adityavardhan Agrawal', 'email': 'adi.agrawal@mongodb.com', 'username': 'Adityav369'}

Message: SERVER-75890 Add system/user connection and collection type info to currentOp and slow query logs
Branch: master
https://github.com/mongodb/mongo/commit/6e95344683de6040f1b932ad1bc4c0c5744906ac

Generated at Thu Feb 08 06:31:19 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.